Filter Former Employees out of Combo Box List

[millerprm]

I have a combo box based on an employee table. I would like a former employee's name to be removed as a choice combo box list, but their name kept in the employee table (and noted as an former employee) and other records related to them. Any ideas are greatly appreciated.

[Bob Fitz]

You could add a True/False field to your table of employees and perhaps name it CurrentEmployee. This would enable you to determine which employees are current and which are not. You could then use this field for the criteria in the query of your combo box

[Dal Jeanis]

Basically, you base the combo box on a query, rather than a table, and write the query to exclude anyone you don't want in that particular combo box.

As Bob said, the query could use a yes/no field for CurrentEmployee, or a non-null termination date, or whatever other way you might identify the active employees from the inactive ones.

[millerprm]

Basically, you base the combo box on a query, rather than a table, and write the query to exclude anyone you don't want in that particular combo box.

As Bob said, the query could use a yes/no field for CurrentEmployee, or a non-null termination date, or whatever other way you might identify the active employees from the inactive ones.

Thanks for the reply. I based the combobox on a query. The issue I'm having is after I check the former employee box, the record with the name in it is no longer visible in the subform (the record is still in the table). the count says 1 of 4, but there are only 3 names showing. thanks for your time!