View Single Post
  #2  
Old July 3rd, 2005, 03:04 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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.

--
Good luck

Jeff Boyce
Access MVP

"Graeme at Raptup" Graeme at wrote in
message ...
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.