Removing name from dropdown

[scott04]

Hi everyone,

I have inherited a split database and have a quick question. I have a form
that contains a dropdown with employee names. If an employee leaves the
company i want their name to no longer be in the dropdown. I know if i
remove the employee entirely i will delete all the records that they are
associated and i do not want this to happen. What is the best way to
accomplish this?

 

[Jeff Boyce]

A common way to "fill" a drop-down list is to use a query against a table.
If that is how your combobox is being filled, you could:

* add a field to the table to show "TerminationDate"
* modify the query that fills the combobox to exclude employees with a
TerminationDate in the past (i.e., <Date())

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[scott04]

Jeff,

After looking at this design it looks like the creator used the wizard. Do
you suggest that i delete the field from the form and redesign with new combo
box?It looks like the name is coming from the tblOperatorName table that
lists just the bound column 1 that contains the names. Can you explain how i
might be able to incorperate your solution into my problem? Thanks and I
appreciate your response.

 

[Jeff Boyce]

Please review my previous post...

* add a field to the underlying table
* modify the query to check for dates in that new field

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP