Form.DataSetChange Event (Access)

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

Form Object Members