Subform problem

[Novice1]

I have a training event form. I have a subform listing the attendees of the training event. The table of attendees has an Inactive field (Y/N), to identify current or past employees.

When I add a new event, I want the subform to list only current employees but it lists ALL employees in the table (current or past).

When I filter out the Inactive employees, previous training events will not show the past employees as attending the event.

I tried modifying the query on the main form; the query subform and the combo box options (bound to TraineeID but shows the Last name of the trainee) without success.

How do I show all attendees (inactive) for prior training events but only show active employees (combo box options) for a new training event?

 

[Minty]

You could simply have an add event form that only showed the current attendees.
Or have a command / toggle button that changes the subform to only add records and changes the record source of the combo. When you toggle back to "viewing" mode it resets the sub form to not allow additions but show all attendees in the combo row source.