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


© Copyright SS64.com 1999-2013
Some rights reserved