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

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top