OK, i have a form with 3 controls. 1 x textbox, and 2 combo boxes. The scenario is like capturing students taking courses in a specified week number. e.g.
TxtWeekNo CboCourse TxtStudentName
1 Engineering Joe Bloggs
1 Engineering Jay Rock
1 Law Mary Joe
2 Engineering <Nothing to select!>

What i want to do is upon selecting the course, i want to filter for students not already specified for that week and course.
Referencing the above table, when i select "Engineering", i have two students in the combo dropdown Joe & Jay, where i specify Joe in the first instance. In the second record, for the same week and course, i only have one student to select - Jay.
The query i have works well for week 1 BUT when i start with week two, if i specify Engineering, i have NO MORE STUDENTS TO SELECT! I'm pretty sure there is a way to refresh the box for new weeks. PLEASE HELP!!!