Pause Macro Then Resume

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

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.
 
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.
 
Thanks for the good advice.

Steve Schapel said:
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.
Click to expand...
 
Back
Top