Hiding values in a combobox

[Guest]

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?

 

[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.

 

[Guest]

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.

 

[Guest]

Ok active/inactive field it is. Thanks for the info guys.

 

[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