Macro - query - form

[texasalynn]

I need some help with a macro problem. I have a form that has a drop-down box that a user will select what query to run. There is a button on the form that will run the query based on the selection of the drop-down box. ????I'm lost here. I know how to write the macro to run a specific macro, but not how to based on variables. (e.g. Query 1, or query 2, or query 3, etc) Please help

texasalynn

 

[Rob.Mills]

In your macro under the conditional column you would type something like:

Forms!frmName!Combobox=QueryName

Then on that same line the action would be to open that query.

Next line would look the same as above but with another query.

You would repeat this process for each of the selections in the combo box and the macro would carry out based on the selection.

Hopefully my explanation is clear enough.