Cascading Combo Boxes

[Guest]

Hello All,

I have three Cascading Combo Boxes. The first is the Instructor then
limited by instructor is the course and then the availible test.

I having problems with the third combo box it lists all the availible test
for the course rather then for the specific instructor and course combined.

Here is the Row Source:
Combo1
SELECT DISTINCT taf.Professor FROM taf;

Combo2
SELECT DISTINCT Taf.course FROM Taf WHERE (((TAF.professor) Like
forms!TestingSignInFm!combo0));

Combo3 (The Problem)
SELECT DISTINCT Taf.test FROM Taf WHERE (((TAF.course) Like
forms!TestingSignInFm!combo2));

I assume the problem is I need an and Taf.professor, but everything I tried
did not work.

Thank you
David

 

[Dan Artuso]

Hi,
Try this:
SELECT DISTINCT Taf.test FROM Taf WHERE (TAF.course Like
forms!TestingSignInFm!combo2) AND (Taf.professor Like forms!TestingSignInFm!Combo0);