Hiding values in a combobox

P

P51D Mustang

I have a form with a combobox used to select employees who did something.
Over time, my employees table (and thus the combobox used to select an
employee) has gotten rather cluttered.

Is there a way I can hide the records in the Employees table from the
combobox--to only show the active employees?
 
R

Rick B

Sure. Add an inactive or active flag to your table and base your combobox
on a query.

Or, you might add a "termination date" field and filter based on that.
 
K

Klatuu

If you have a field that will tell you whether an employee is active, you
can use a query filtered on that field as the rowsource for your combo.
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
Top