I am posting this question as a follow up to the question at this link:
I have a form with two unbound combo boxes, one for the course and one for the preferred session of that course. Each are located in the header of a continuous form which displays each request submission that has not been assigned to a session. The user is able to filter the list based upon both the class and the preferred session.
I need to add the cascading functionality so that if the user filters the list by course only the preferred sessions for the requests for that particular course show up in the preferred sessions filter combo.
Here is the SQL I have for each combo box:
urse, tblCourses.CourseName FROM tblCourses INNER JOIN qryReqPendingAssignment ON tblCourses.CourseID = qryReqPendingAssignment.Co
urse UNION SELECT Null, '(View All)' FROM qryReqPendingAssignment
ORDER BY tblCourses.CourseName;
sion, tblEvents.EventDesc FROM tblEvents INNER JOIN qryReqPendingAssignment ON tblEvents.EventID = qryReqPendingAssignment.Pr
sion UNION SELECT Null, '(View All)' FROM qryReqPendingAssignment
ORDER BY tblEvents.EventDesc;