Is there a way to set this

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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?
 
Back
Top