PivotTableChange Property [Access 2003 VBA Language Reference]
Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the PivotTableChange event occurs. Read/write.
expression Required. An expression that returns one of the objects in the Applies To list.
Valid values for this property are "macroname" where macroname is the name of macro, "[Event Procedure]" which indicates the event procedure associated with the PivotTableChange event for the specified object, or "=functionname()" where functionname is the name of a user-defined funciton. For a more detailed discussion of event properties, see "Event Properties ."
The following example specifies that when the PivotTableChange event occurs on the first form of the current project, the associated event procedure should run.
Forms(0).PivotTableChange = "[Event Procedure]"
Applies to | Form Object