Combo selection

[texasalynn]

I'm trying to create a form that will let the user select which query to run from the combo box? How do I do that? Whenever I select the combo box it wants me to pick only one. Do I have to do something else; maybe to put all the query names in a table? As you can tell this is new to me and I'm at a loss how to go about this.

Thanks . . . texasalynn

 

[Dugantrain]

The easiest way is just to write all of your queries into a table, make that table the recordsource for the combo box, and then tell it to open that query in the After_Update event of the combo box. I'm not sure about your experience with VBA, but the procedure would be:

Your_combo_after_update()
docmd.open query Your_combo, acnormal, acedit
End Sub

*You can actually have the database write its queries to a table automatically, but that takes quite a bit more code to accomplish. Search around for examples if you're interested.