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.
 
Back
Top