Attachment.Requery method (Access)

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

Syntax

expression.Requery

expression A variable that represents an Attachment object.

Remarks

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 functions.

If you specify any other type of control for the object specified by expression, the record source for the form is requeried.

If the object specified by expression 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 specified by expression, the Requery method requeries the underlying data source 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 requeries the record source only for the subform, not the parent form.

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.