Using existing data in criteria query

R

Robin Chapple

I have a criteria query which is based on people's names. Spelling is
causing many problems.

Can I include a drop down menu of existing names so that spelling is
no longer needed?
 
J

Jeff Boyce

Robin

Yes, you can use a combo box to look up existing names.

No, you cannot do so from within a query.

The way you do that is via a form. Put the combo box on the form, and
modify your query to point to the form to get its parameter/selection
criterion.

The "cell" in the query will look something like:

Forms!YourNewForm!cboYourNewComboBox
 
Top