Show Me Microsoft Office Access 2003

The Visual Basic Editor provides several tools to help you write error-free code. However, sometimes a procedure does not act the way you expect it to. To deal with this problem, you can use the Editor's debugging tools to help you locate the source of the trouble. One the most common approaches to debug failed code is to "walk through" the procedure step by step, examining each thing the procedure does. In this way, you can try to locate the exact statement that is causing you trouble.

Stepping Through a Procedure

Click the View menu, point to Toolbars, and then click Debug.

Click the first line of the procedure you want to debug.

Click the Step Into button on the Debug toolbar to run the current statement and then to move to the next line in the procedure.

Continue clicking the Step Into button to move through the procedure one line at a time, examining the results of the procedure as you go.

Click the Stop button on the Debug toolbar to halt the procedure at a specific line.