If this employee was deleted, make combobox to be disabled and also add some other visual clue (say, label at the top), saying, that this employee is no longer working in the company.
>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
If it's not broken, fix it until it is.
My Blog