Using existing data in criteria query

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
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?
 
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
 
Back
Top