Table of contents
Collapse the table of content
Expand the table of content

Form.PivotTableChange Property (Access)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

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

See also


Form Object

© 2017 Microsoft