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.

Syntax

expression .PivotTableChange

expression A variable that represents a Form object.

Remarks

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.

Example

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

See Also

Concepts

Form Object

Form Object Members