Sending multiple reports with same parameters

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
 
K

KARL DEWEY

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.
 

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