Microsoft Access VBA Macro Programming

After selecting Set Field, you will see a design window for your particular action to set a

field value. Enter the name of the field asNumber2and the value as3*[Number1]. Your

design window will now look like Figure 13-4.

168 Microsoft Access 2010 VBA Macro Programming

Figure 13-3 Adding a new action