combo boxes

sparky2005

New member
Local time
Today, 14:05
Joined
Nov 15, 2005
Messages
6
I have created a query to simply bring up various parameters asking questions which then give back the results that are correct! i am wondering if it is possible so that when the parameter boxes display on the screen, for you to be able to select the answer from a combo box list (within the parameter box) instead of typing them in???

Cheers
 
I don't use parameter queries for this. Here's what I do...
Create an unbound form with as many comboboxes as you need.
Reference the comboboxes to queries which extract the unique values from the fields you are interested in.
In the query which delivers the final result, in the criteria cell for the field required, reference the result of the combobox in the unbound form.
Finally create a command button on the unbound form to run the query when all combos have been filled out.
Hope that helps
 

Users who are viewing this thread

Back
Top Bottom