The Query event occurs after a PivotTable view sends a query to its data source. Actions such as adding new fields to the PivotTable report, moving fields, and sorting and filtering data will trigger this event. There is no way to determine what type of query has been performed.

Event Programming in Forms and Reports

The procedure in Hands-On 24-22 demonstrates how to change the mouse pointer to an hourglass before the query is sent to the data source and how to turn off the hourglass pointer after the query has run. Prior to sending the query, we also ask the user to specify the background color of the detail rows.

0 0

Post a comment