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

D

Duane Hookom

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.
 
T

TORY

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.
 
D

Duane Hookom

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