Filter non-text data

[bdriscoll]

I have a project table linked to the employee table by employee ID. I have a drop down box that lists the current active employees. Their name is displayed in the drop box, but a number(employee ID) is stored in the table.

I start the project form with a defaut filter of active projects. If I want to add to this filter, I can right click on a drop down box like "status" and pick "awarded". This furthur filters the records to active and status-awarded.

However, if I want to filter on manager, right click on that field and add equal whoever the current manager is I get an error. How can I filter on manager, when the data stored in the table is actually a number?

TIA,


bdriscoll

[dcrake]

Are you using comboboxes in your datasheet view? if so, I suggest you remove the functionalitiy and use queries to get the names.

David

[bdriscoll]

I am using a combo box with a query as the source, but the stored information is the employee number, not the name. I don't think the quick text filters you can do with the right click are going to work on these combo boxes.

bdriscoll