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
Rob