Select query based on a user choice (1 Viewer)

[rodin]

Hi,

I would like to run a simple select query, where the CRITERIA is based on the user choice.
I have a form with a combo box, with a few choices, and a button that will trigger a macro with one query for now. I can store the choice in to a variable e.g. "town", using Microsoft VB code.
How can I transfer the variable to the CRITERIA field in the query, so whenever I chose a specific "town", my query will select the records for that specific town.
I want to use one query, and I don't want to have to "hard type the criteria in to the cells' query", but I would like to use a variable that can change and will be read it from the user choice through combo box.

If I am not clear enough, please let me know.

Thank you!

 

[MStef]

Hello rodin!

You don't need a Macro, you don't need a variable,
you don't need a command button.
Look at "DemoCoboQueryA2000.mdb.

 

[rodin]

Thank you! It is working.