selecting criteria from a field with drop down menu

K

karenSFO

I would like to build a query selecting criteria from a field with a drop
down menu. There are about a dozen choices in the drop down and I would only
like to see 4 of them. When I type them in the criteria box, the pop up
states: This expression is typed incorrectly, or it is too complex to be
evaluated...
 
J

Jeff Boyce

Access queries, by themselves, don't have drop-down menus.

A way to get a drop-down menu is to create a form with a combobox control.
Then modify the Selection Criterion in your query to "point" at that form's
combobox with something like:

Forms!YourForm!cboYourComboBox

Note that the form has to be open for this to work...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria Query Error Please Help 4
Drop down lists 2
Add to drop down menu. 3
Query Criteria part 2 2
Using a drop-down box to sort data based on seperate columns 2
Between Function (with dates) 5
Table field drop-down menu 3
Data type mismatch in criteria expression 8

Top