Synchronizing a Form with Its Underlying Recordset

A form's RecordsetClone property is used to refer to its underlying recordset. You can manipulate this recordset independently of what's currently being displayed on the form. Here's an example:

Private Sub cboCompany_AfterUpdate()
   Me.RecordsetClone.FindFirst "[ClientID] = " & cboCompany.Value
   If Me.RecordsetClone.NoMatch Then
      MsgBox "Client Not Found"
   Else
      Me.Bookmark = Me.RecordsetClone.Bookmark
   End If
End Sub