Hide value in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Purchase Order database. I have a combo box that pulls employee
names from a table. Is there a way to hide employee names after they have
left the company from showing up in the combo box? I still need their names
in case we need to look up an old purchase order they created.

Thanks!
 
Add an "Active" field (yes/no type) to the table where the employee names
are stored. Then have the combo box's Row Source query include a criterion
to only select Active employees.
 
jped said:
I have a Purchase Order database. I have a combo box that pulls
employee names from a table. Is there a way to hide employee names
after they have left the company from showing up in the combo box? I
still need their names in case we need to look up an old purchase
order they created.
Click to expand...

Have a "Terminated" flag (yes/no field) or a "TerminationDate" field in
the Employees table, and set yur combo bxo's rowsource to a query that
selects only the non-terminated employees; that is, those where
Terminated = False, or TerminationDate Is Null, depending on how you
set up the table.
 
That worked great! Thank you so much!

Ken Snell said:
Add an "Active" field (yes/no type) to the table where the employee names
are stored. Then have the combo box's Row Source query include a criterion
to only select Active employees.
Click to expand...
 
Back
Top