Edit

Share via

Form.DataSetChange event (Access)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.