pausing a macro

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

 

[Steve Schapel]

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.

 

[Steve Schapel]

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?