Employee Quit?

[pinkapepink]

I have a form which has a drop down box which links to a table with Employee names. One employee quit and I want to delete her name from the table. But... if I do that, I will delete her entirely from all previous records. Is there a way to keep all previous records, but take her out of the drop down choices?
Thanks!

 

[raskew]

Hi -

Does your table include a HireDate and DepartureDate (or fields to that effect)? If so, select only those records where DepartureDate IsNull.

HTH - Bob

 

[pinkapepink]

Worked Great! Thanks!