Form.DataSetChange Event

  • Article
Access Developer Reference

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.

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