Syntax
Private Sub QueryTable_AfterRefresh(Success As Boolean)
Enter
Code
End Sub
This event occurs after a query is completed
or canceled.
Required Parameters
Success
The success parameter will return a value of
true if the query was completed successfully. It will return a value of false
if the refresh failed or was cancelled.
Example
Private Sub QueryTable_AfterRefresh(Success As Boolean)
If
Success Then
'
Query completed successfully
Else
'
Query failed or was cancelled
End If
End Sub
Result
This example uses the Success argument to
determine which section of code to run.
