running macros multiple times

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

Hello and thanks in advance!
I need some help with a project I'm doing in which I
have a macro that prints several different reports at
once. What I need is a form that will allow the user to
input the number of copies of this "report series" they
need. For example I may need 5 copies 3 different
reports, so I would need the macro to run 5 times
consecutively. Any ideas? Thanks again!!
 
Tara,

You can set up a secondary macro, using the RunMacro action, and in
the RepeatCount argument you can refer to the textbox on the form
where you have entered the number of copies, the equivalent of...
=[Forms]![NameOfForm]![CopiesTextbox]

- Steve Schapel, Microsoft Access MVP
 
Thanks for the help Steve! It worked great...

Tara
-----Original Message-----
Tara,

You can set up a secondary macro, using the RunMacro action, and in
the RepeatCount argument you can refer to the textbox on the form
where you have entered the number of copies, the equivalent of...
=[Forms]![NameOfForm]![CopiesTextbox]

- Steve Schapel, Microsoft Access MVP

Hello and thanks in advance!
I need some help with a project I'm doing in which I
have a macro that prints several different reports at
once. What I need is a form that will allow the user to
input the number of copies of this "report series" they
need. For example I may need 5 copies 3 different
reports, so I would need the macro to run 5 times
consecutively. Any ideas? Thanks again!!
Click to expand...

.
Click to expand...
 
Back
Top