Is there a way to set this

G

Guest

I have several reports that are based on parameter queries. I'd like to get
a macro set to run all of the reports in sequence, and I've got that part
down. But my question is there a way to set the value so that the macro
doesn't require the input for each reprot as it opens? The criteria will be
the same for each report when the macro is run.
 
G

Guest

Use a form to enter the value and use the form's TextBox as the criteria.
Have the macro run upon completion of the TextBox or a command button. Add a
step in the macro to close the form.
 
G

Guest

Karl,

I've got the form and have the criteria for the report to look at the form.
However, when I enter the date in the form and hit the command button to run
the macro I STILL get asked for the dates.

Obviously I am missing some small detail. Ideas?
 

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