I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see their courses and the certificate they are in. My question is: I need to create a form with drop-down's that will select a course then return a report with students that have not taken that course within that certificate. I have tried queries, macros, etc. I'm not as competent on Access 2007 as I was with the earlier versions. But I've been working on this for some time and can't figure it out. I don't know much about the codes. Could someone help walk me through this? I'm taking courses later this summer, but we need this information now!