Requery

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

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


 
Copyright © 1999-2024 SS64.com
Some rights reserved