Dear Richard,
I have the following problem with access:
I have a table with members.  Members can be active or non-active.  I made a query to select only active members.  
I organise meetings. For each meeting I use a continuous form to enlist members who visited that meeting.  In this  form I use a combobox to select members from the query.  
Now when I change a member to non-active, then i get blank fields on forms of meetings this member visited in the past. This  member is still registered to these meetings, because when I print the meeting report, his name  is on the report.  It  just dont show anymore in the combo-boxes on the forms.
Have you  covered  this in one of your lessons?  Or do you know how to solve this problem?
Thanks in advance.
Arjan

---

Reply from Alex Hedley:

The Form can have a query that uses only Active members but when it comes to your reports don't filter on this if you want to see them historically.