Hide some choices in combo box?

[Autoeng]

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history. Is there a way to hide their names from being displayed in the combo box?

 

[edtab]

You can create a query and eliminate the names you do not
want to show via the field criteria definition. (e.g. under the name
field, enter "<> username"). You can specify multiple names here.

This query should now the row source of your combo box.

HTH

 

[jfgambit]

Add a field to the Names table "Active" (Yes/No). For those individuals no longer with the company update that field to a "No". Filter your combobox based on the "Active" field to show only "Yes". This way when an employee leaves you just need to make the "Active" field "No" and they will no longer appear on the combobox, and you do not need to delete them from the database.

HTH