Query linked to form

[Daryl2106]

Hi Everyone,



I am a new user. I have a form linked to a query, that allows me to enter a teachers name from a combo box, and then I have a button that runs an embedded macro to run the query.

The data I am trying to selct is contained in three linked tables. The first has the instructor information that includes the courses the teach. The second is a student enrollment table (the two are linked by a course number) and the third has the students contact info including name which is linked to the enrollment table by student number.

The criteria I am using is [Forms]![TeachersEnrollmentQuery]![InstructorName].

I am just not getting any records in my query.

Any help is greatly appreciated.

Thanks and take care,

Daryl

[alansidman]

Here's a tutorial on cascading combo boxes.

http://www.fontstuff.com/access/acctut10.htm

Alan

[Daryl2106]

Hi,

Thanks for the reply. I am still having troubles getting my query to return the desired records. Here is the SQL I am using in the query:

SELECT CourseInventory.Instructor
FROM CourseInventory
WHERE (((CourseInventory.Instructor)=[Forms]![TeachersEnrollmentQuery]![InstructorName])) OR (((IsNull([Forms]![TeachersEnrollmentQuery]![InstructorName]))<>False));

The Instructor Name on the form (TeachersEnrollmentQuery - not the best name!) is selected from a combo box that chooses from a Instructor table. The query is run from a button on a form containing an "OpenQuery" embedded macro.

Sometimes I get a single digit in the "Instructor" column (only column shown) but most times I get nothing.

Thnaks for your help.

Take care,

Daryl