Requery Method (Control or Form Object)

Applies To   Combo Box control, Control object, Form object, List Box control, Page.

Description

The Requery method updates the data underlying a specified form, or a control that's on the active form, by requerying the source of data for the form or control.

Syntax

[object.]Requery

The Requery method has the following argument.

Argument

Description

object

A Form or Control object representing the form or control you want to update. Omit this argument to requery the source of data for the active object.


Remarks   You can use this method to ensure that a form or control displays the most recent data.

The Requery method does one of the following:

  • Reruns the query on which the form or control is based.
  • Displays any new or changed records or removes deleted records from the table on which the form or control is based.
  • Updates records displayed based on any changes to the Filter property of the form.
Controls based on a query or table include:

  • List boxes and combo boxes.
  • Subform controls.
  • OLE objects, such as charts.
  • Controls for which the ControlSource property setting includes domain aggregate functions or SQL aggregate function.
If you specify any other type of control for the object argument, the record source for the form is requeried.

If the control specified by the object argument isn't bound to a field in a table or query, the Requery method forces a recalculation of the control.

If you omit the object argument, the Requery method requeries the underlying source of data for the form or control that has the focus. If the control that has the focus has a record source or row source, it will be requeried; otherwise the control's data will simply be refreshed.

If a subform control has the focus, this method only requeries the record source for the subform, not the parent form.

Notes

  • The Requery method updates the data underlying a form or control to reflect records that are new to or have been deleted from the record source since it was last requeried. The Refresh method shows only changes that have been made to the current set of records; it doesn't reflect new records or deleted records in the record source. The Repaint method simply repaints the specified form and its controls.
  • The Requery method doesn't pass control to the operating system to allow Windows to continue processing messages. Use the DoEvents function if you need to relinquish temporary control to the operating system.
  • The Requery method is faster than the Requery action. When you use the Requery action, Microsoft Access closes the query and reloads it from the database. When you use the Requery method, Microsoft Access reruns the query without closing and reloading it.
See Also

Recalc method, Refresh method, Repaint method, Requery action, Requery method ("DAO Language Reference"), Requery method (DoCmd object).

Example

The following example uses the Requery method to requery the data from the EmployeeList list box on an Employees form:

Sub RequeryList()
    Dim ctlList As Control

    ' Return Control object pointing to list box.
    Set ctlList = Forms!Employees!EmployeeList
    ' Requery source of data for list box.
    ctlList.Requery
End Sub