In Access 97 how do I query using a combo box?

  • Thread starter Thread starter Guest
  • Start date Start date
Feel free to use the big white space to give us information about your
needs.

A wag suggests that you are attempting to use a combo box for a parameter
prompt. This won't happen. Use controls on forms to get user input for
everything in your application other than MsgBox prompts.
 
Indeed Duane, that was my question.

In my database I wish to query on County. The Countys are in a table and
therefore appear on the form in a combo box. So can I set a query and the
combo box will appear rather than the user having to retype the County they
are querying on??

Many thanks for your help already in this matter.
 
Combo boxes only reside on forms. If you are using a parameter query,
consider kicking your application up a notch and remove all parameter
prompts.

Add a combo box to a form that allows the user to set the criteria. If the
"queried" records feed a form or report, I would suggest using the combo box
value in the Where clause of the DoCmd.OpenForm/Report.
 
You must log in or register to reply here.

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

Similar Threads

Query with results in a value list from a combo box? 1
Using combo box(s) to create a query 1
How to use txtboxes and Combo boxes in a form 3
Combo Box in a Query 3
Using a combo box as a criteria for a query 1
Basing a query on the selection in a Combo box parameter 2
Insert query from Access 97 to 2002 4
combo box column value in query 7

Back
Top