DoCmd.SingleStep method (Access)
Pauses macro execution and opens the Macro Single Step dialog box.
expression A variable that represents a DoCmd object.
The SingleStep method will not stop the execution of or assist in debugging Visual Basic for Applications (VBA) code. Use the Stop statement to pause execution of VBA code.