selecting criteria from a field with drop down menu

  • Thread starter Thread starter karenSFO
  • Start date Start date
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...
 
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
 
Back
Top