I am using access. I have queried a table using a form to trigger the query, with three combo boxes(cascading) the results how ever are not based on the three criteria, only the first. The code below was written to allow the cascading boxes. However I would like the results for location = the respective combo box and cant find the way to insert the code, all methods tried resulted in a failed cascading combo box.
SELECT DISTINCT OFFERING.Lecture, OFFERING.Course_no, OFFERING.Location,OFFERING.Start_date FROM OFFERING, COURSE WHERE OFFERING.Course_no=[forms]![Form1]![Combo0];