running macros multiple times

[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!!

 

[Steve Schapel]

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

 

[Guest]

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!!

.