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

Form.DataSetChange Event (Access)

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

Occurs whenever the specified PivotTable view is data-bound and the data set changes — for example, when a filter operation takes place. This event also occurs when initial data is available from the data source.

Syntax

expression. DataSetChange

expression A variable that represents a Form object.

Return Value

nothing

Example

The following example demonstrates the syntax for a subroutine that traps the DataSetChange event.

Private Sub Form_DataSetChange() 
 MsgBox "The data set for the PivotChart view has changed." 
End Sub

See also

Concepts

Form Object

© 2018 Microsoft