Export (0) Print
Expand All
Expand Minimize

Form.PivotTableChange Property (Access)

Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the PivotTableChange event occurs. Read/write.

expression .PivotTableChange

expression A variable that represents a Form object.

Valid values for this property are "macroname" where macroname is the name of macro, "[Event Procedure]" which indicates the event procedure associated with the BeforeInsert event for the specified object, or "=functionname()" where functionname is the name of a user-defined function.

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]" 

Concepts

Other resources

Show:
© 2014 Microsoft