selecting queries from combo box

[ek378996]

How would I select different queries using a combo box?

and i need a button at the end after selecting the query.

[SoftwareMatt]

Set up a table as follows:
ID
QueryName
QueryDisplayName

Then add the relevant details to the table for your queries.

Now on a form populated the combo with the query table.

Add a button with code on the OnClick event as follows:

Docmd.OpenQuery Me!ComboBoxName.Column(1)

Note: you will need to replace the ComboBoxName with whatever name you use for the combo.