Choose a query to run a report on 1

[nuVBer]

I want to be able to allow the user to select a query to be selected from a combo box and have it be the recordsource of a report that I designed and have the report run with that query. I want to do this in vba code, but I can't set the recordsource before the report is run. How do I pass this query name to the report?

 

[Fred]

Write the name of the selected query to a global variable (defined as such, in a module). On the Open Event of the report, assign the global variable to the report's recordsource.