Access VBA Macro Programming

(Joao Candeias) #1
The earliest active procedure call is shown at the top of the list, and any subsequent
procedure calls are added to the top, as shown in Figure 7-2. By highlighting the procedure in
the figure and clicking Show, you can view the statement calling that procedure. This is
indicated with a green arrow.

The Debug Window


The Debug window allows you to set a watch on specific variables or properties to see what
values they hold as your program executes. This will aid you in debugging by allowing you
to analyze a variable or property that has an incorrect value and determine where the problem
is coming from.

86 Microsoft Access 2010 VBA Macro Programming


Figure 7-2 How to call a subroutine and show which procedure called it
Free download pdf