listbox

[Atoga]

Hi Everyone,
In my starting form I have a combobox (Courses) and based on the selection from this, a listbox (Employees) populates.
I added a button next to the listbox in case there are other Employees who would need to be added to that course. This button brings up another form (AddEmployeeForm) where I would like to see only those Employees in a listbox who were not in the listbox in the starting form so that the user can select from among them and add them to the course (by clicking on the Add button). In case the employee is new (not in the Employee list at all), I also would like to have on this AddEmployeeForm a button which brings up another form to enter new employees.


How can I have only those employees in the listbox of the AddEmployeeForm who were not in the listbox in the starting form?
Cheers

[NTC]

Access offers a 'Find Unmatched Query Wizard' ; you would use that type query to establish your record set.