Lookup field in a query

[jwf]

I have a lookup field called AccountManager in a table, I want to use this look up field in a query criteria to get the records I need. Is this possible?

 

[Pat Hartman]

1. Get rid of the lookup field from the table. It is a crutch and causes problems with queries and VBA.
2. Create a form with combos that list the selection options. Then have your query reference the combo on the form:

Where MyField = Forms!frmMyForm!cboMyField