G
Guest
Hi,
I have a combo box that contains employee ID#s. The combo box is based on
an "EmployeeID" table that contains the following fields:
[EmployeeID], [EmployeeName], [Active]
[Active] is a yes/no checkbox. When an employee is not active, he/she no
longer is working with us. So, I would like the combo box to only display
the employees that are currently active. Yet, at the same time, I would like
the ability to enter an old inactive employee's ID# for odd cases.
Does anyone know how to get the combo box to selectively display employees?
Thank you!
Diana
I have a combo box that contains employee ID#s. The combo box is based on
an "EmployeeID" table that contains the following fields:
[EmployeeID], [EmployeeName], [Active]
[Active] is a yes/no checkbox. When an employee is not active, he/she no
longer is working with us. So, I would like the combo box to only display
the employees that are currently active. Yet, at the same time, I would like
the ability to enter an old inactive employee's ID# for odd cases.
Does anyone know how to get the combo box to selectively display employees?
Thank you!
Diana