By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,129 Members | 1,283 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,129 IT Pros & Developers. It's quick & easy.

Combo box for a parameter query

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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.