Hi!

I have a combo box that relates from a main table into an employee file by employee number. All is set up correctly in my data enviroment etc etc.

My problem is when an employee leaves I mark this the employee file.

When a new record is added to the main file, I dont want the employee who has left to appear in my combo list. I achieved this by setting a filter in the data enviorment for my form.

However, I want the employee to show on my form for previous records on my form.

Any ideas?

TIA

RC
BSS