Form.Requery (Access)

The Requery method updates the data underlying a specified form by requerying the source of data for the form.

You can use this method to ensure that a form or control displays the most recent data. The Requery method does one of the following:

Public Sub RequeryList() 
 
    Dim ctlCombo As Control 
 
    ' Return Control object pointing to a combo box. 
    Set ctlCombo = Forms!Employees!ReportsTo 
 
    ' Requery source of data for list box. 
    ctlCombo.Requery 
 
End Sub