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.
 
You must log in or register to reply here.

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

Parameter Query Won't Run 0
No Results Running Parameter Query on Field Using Lookup Table 19
query a multivalued lookup field 8
Custom Form Property, Parameter Query Access 2007 Problem 2
How can I set TEX type parameters in query in lookup type filed? 1
Parameter Query Lookup 2
How do I make query parameters with a drop down list? 1
Access 2007: Need more info on 'concatenante fields' 1

Back
Top