How do you set your parameters in a macro to run a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several reports set up with parameter queries. I need to print all of
these at once but have to continue inputting the dates for the query. Can I
set up a macro to remember this value after I input it once.
 
Have the starter macro open a form with unbound textbox to enter the criteria.
Set the After Update property of the textbox to run the second macro for all
the reports. Put the textbox as criteria in the queries for the reports.
This would look like [Forms]![YourTempForm]![YourTextBox]. The last line in
the macro closes the form.
 
Back
Top