Combo box for a parameter query

[francophone77]

Does anyone know how to setup a parameter query, which allows the user
to choose from a combo box? TIA

[bob]

Have a small form with the Combo Box and whatever other inputs may be
necessary....
and a "go" button....
The query then gets the value from the combobox on the form.....
The key is to have the button run the query, and if you want - hide the
form...don't close it or the query will error out.

Mal.
"francophone77" <fr***********@hotmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

Does anyone know how to setup a parameter query, which allows the user
to choose from a combo box? TIA

[paul]

Here's something I put together that may give you some ideas about
making time periods and other criteria dynamic.

The free downloadable sample database at www.bullschmidt.com/access
uses the query by form concept so that on the invoices dialog one can
optionally choose a rep, a customer, and perhaps a date range, click on
a button that says "Input," and then have the invoice form open up
showing all the invoices that match the criteria.

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

Does anyone know how to setup a parameter query, which >allows the user
to choose from a combo box? TIA