Show All

Find problems in a macro by single stepping through it

By single stepping through a macro, you can observe the flow of the macro and the results of each action, and isolate any action that causes an error or produces unwanted results.

1. Open the macro.

   How?

   1. In the Database window, click Macros under Objects.
   2. Click the name of the macro you want to open.
   3. Click the Design button on the Database window toolbar.

2. Click Single Step on the toolbar.

3. Click Run on the toolbar.
4. Do one of the following:

   To carry out the action shown in the Macro Single Step dialog box, click Step.

   To stop the macro and close the dialog box, click Halt.

   To turn off single stepping and run the remainder of the macro, click Continue.

Tip

You can also stop a macro while it's running and then single step through it by pressing CTRL+BREAK.