Query Event

Microsoft Access Visual Basic

Query Event

       

Occurs whenever the specified PivotTable view query becomes necessary. The query may not occur immediately; it may be delayed until the new data is displayed.

Private Sub Form_Query()

Example

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

Private Sub Form_Query()
    MsgBox "A query has become necessary."
End Sub