pausing a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

not sure this is possbile -- I have a common form that set's parameters for
reports. My idea was to have a macro open the form, let the user set the
parameters then have the report open. I didn't want to put code into the
form for onclose because I'd like to use the form for a variety of reports.
Is there any way make a macro open a form the have it continue once the form
is closed (there will be a seperate macro for each report). Thanks.
 
Ian,

If you set the Popup property of the form to Yes, may be what you're after.

How is the macro supposed to know which report to print?

I guess the most common approach here would be to have a command button
on the form where you enter the criteria, with a separate macro on this
command button to launch the report.
 
Ian,

As I said before...

If you set the Popup property of the form to Yes, may be what you're after.

How is the macro supposed to know which report to print?
 
Back
Top