Sending multiple reports with same parameters

  • Thread starter Thread starter Rick D
  • Start date Start date
R

Rick D

I am trying to send multiple reports with same parameters through a macro. I
can set everything up except that it asks for every reports parameters as it
goes to send it. Is there a way to do this through a macro maybe. If so how?
Is there another way I should be going on this? Any help would be greatly
appreciated.

Thanks
 
Use unbound form with unbound text boxes for parameter entry.
Refer to text boxes in criteria of query for report like this --
[Forms]![YourFormName]![TextBox1]

Open form, enter parameters, leave form open, run repports.
 
Back
Top