Please help

[arsh]

I have a form with two combo boxes.ComboTeachers(TeacherID,TeacerName) and ComboStudents(StudentID,StudentName).ComboStudents is filtred by ComboTeachers and shows students of the teacher which is selected in ComboTeacher.When I click a student in a combo by after update event opens a query that shows student information from TableStudents. I want to have "all" in ComboStudent and when I click I want to see a query with all student information.How can I do it.Thanks in advance.

 

[Jonathan Kok]

Check out the attached database search form.

If you look at the source of the comboboxes, you can see that it uses a 'UNION SELECT' to add the 'all' option to the list. You could certainly do a similar thing here.