Pause Macro Then Resume

[Guest]

I would like to pause a macro at a certain point to allow the user to enter
data in a query that opens, then close the query and the macro resumes at
that point and finishes.

 

[Steve Schapel]

lreecher,

The recommended approach here would be to make a form based on the
query, and open the form for your user's input, rather than opening the
query datasheet itself. (As a matter of fact, it is *never* a good idea
to expose a query datashewet in normal dataqbase usage!)

Then, split the macro into two. The first part of the macro runs to the
point that the form opens. Then, put a command button on the form, and
assign the second part of the macro on the Click event of this button,
which the user clicks after they have done their data work.

 

[Guest]

Thanks for the good advice.

lreecher,

The recommended approach here would be to make a form based on the
query, and open the form for your user's input, rather than opening the
query datasheet itself. (As a matter of fact, it is *never* a good idea
to expose a query datashewet in normal dataqbase usage!)

Then, split the macro into two. The first part of the macro runs to the
point that the form opens. Then, put a command button on the form, and
assign the second part of the macro on the Click event of this button,
which the user clicks after they have done their data work.