DoCmd.Requery method (Access)
Carries out the Requery action in Visual Basic.
expression A variable that represents a DoCmd object.
|ControlName||Optional||Variant||A string expression that's the name of a control on the active object.|
You can use the Requery action to update the data in a specified control on the active object by requerying the source of the control. If no control is specified, this action requeries the source of the object itself. Use this action to ensure that the active object or one of its controls displays the most current data.
If you leave the ControlName argument blank, the Requery action has the same effect as pressing Shift+F9 when the object has the focus. If a subform control has the focus, this action requeries only the source of the subform (just as pressing Shift+F9 does).
If you want to requery a control that isn't on the active object, you must use the Requery method in Visual Basic, not the Requery action or its corresponding Requery method of the DoCmd object. The Requery method in Visual Basic is faster than the Requery action or the DoCmd.Requery method.
In addition, when you use the Requery action or the DoCmd.Requery method, Microsoft Access closes the query and reloads it from the database, but when you use the Requery method, Access reruns the query without closing and reloading it. Note that the ActiveX Data Object (ADO) Requery method works the same way as the Access Requery method.
The following example uses the Requery method to update the EmployeeList control.
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.