Access VBA Macro Programming

(Joao Candeias) #1

If you need to edit your action, simply click the Set Field text in the action. This will bring
you back to the design section.
Save the table by clicking the Save icon and then close the table macro window.
Open the table in View Mode by clicking the View icon in the Views group of the ribbon
and entering a new value into the Number1 field. You will find that the Number2 field is
automatically populated with three times the value of Number1. Even if you enter a value
into the Number2 field first, it will still be overwritten by the table macro.


Chapter 13: Table Macros 169


Figure 13-4 The design window after a new action has been added

Free download pdf