How do you select which query?

[vince99]

How can you select which query you want to run by using a drop down box?

Thanks In Advanced

 

[TheInsider]

Hello,

Modify the following sample code:

Sub QueryDefSample()
Dim q As QueryDef
For Each q In CurrentDb.QueryDefs
MsgBox q.Name
Next

Set q = CurrentDb.QueryDefs("x&quot
DoCmd.RunSQL (q.SQL)
End Sub

Use the For Each loop to obtain a list of available queries and place them into the Combobox field list. Then, when the user selects a query from the list, use the second part of the code to run the query that corresponds to their selection. Rob Marriott
rob@career-connections.net