Requery the data in a form or a control.



   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 will repaint the specified form and its controls.

The Requery method in Visual Basic is faster than the Requery action or the DoCmd.Requery method.


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


RefreshRecord - Refresh the data in a form

Copyright © 1999-2024
Some rights reserved