How do I create a lookup parameter query in Access? (e.g. Find x)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to create a "search" type query similar to those you'd find on a
website with a drop-down list. The field in question is a lookup in the form
but I want the user to be able to select from a drop down list in the
parameter query prompt.
Maybe there's another way to reach the same objective?
Either way, help would be much appreciated.
 
Graeme

Parameter queries only allow for the popup [Enter your value here] approach.
However, if you create a form with a combo box that gives the choices, you
can modify your parameter query to look at the form's combo box to get its
search criterion. Use something like (your syntax may vary):

Forms!YourNewFormName!cboYourComboBoxName

in the selection/criterion row under your field in your query.
 
Back
Top