Pause Macro, take action, then continue

[sahafi]

My macro start running a number of queries, then opens a form, then continue
with the actions. I would like the macro to execute the queries actions, open
the form then pause here to let me click on a command button on the from,
close the form, then the macro can continue with the rest of the actions. How
can I do that? Or can the macro execute the click event procedure on the form?

Thanks.

 

[Steve Schapel]

Sahafi,

In the OpenForm action in your macro, you could try setting the Window
Mode argument to Dialog.

 

[sahafi]

Thanks Steve. Just what I needed.