Requery the data in a form or a control.
Syntax
DoCmd.Requery(ControlName)
Form.Requery
Key
ControlName The name of a control to requery.
Form The name of a form to requery.
The Requery method will update the data underlying a form or control to reflect new/ deleted records since last queried.
The RefreshRecord method will update the current records to reflect changes. If a row in the record source has been deleted, it will change to show #Deleted.
The form.Repaint method simply repaints the specified form and its controls.
The Requery method in Visual Basic is faster than the Requery action or the DoCmd.Requery method.
Examples
DoCmd.Requery "cmbSuppliers"
“My mother made me a scientist without ever intending to. Every other Jewish mother in Brooklyn would ask her child after school: So? Did you learn anything today? But not my mother. “Izzy”, she would say, “did you ask a good question today?” That difference – asking good questions – made me become a scientist” ~ Isidor Isaac Rabi
Related:
RefreshRecord - Refresh the data in a form