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

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

Guest

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?
 
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.)
 

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

Back
Top