How can I set up a combo box to select values in a parameter quer.

W

Wayne

How can I set up a parameter query so that when I'm prompted to provide a
value, I can select the value from a Combo Box instead of having to type it
in?
 
A

Allen Browne

The parameter dialog offered by the query does not support combos, so you
will have to open a form and put the combo there.

You can then put something like this into the query:
[Forms].[MyForm].[MyCombo]

Like all query parameters, you should still declare this by typing exactly
the same thing into the Parameters dialog, and specifying the data type.
(Parameters on Query menu, from query design.)
 
Top