G
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
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