Requery ALL controls on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to requery ALL the controls on a form without having to
identify each individual control in the DoCmd.Requery "ControlName"?
 
Requerying the form, should do it, but you can walk through the controls and
requery them with something like (air code):

Sub RequeryForm()Dim frm As Form
Dim ctl As Control

For Each ctl In frm.Controls ctl.Requery Next ctl
Set ctl = Nothing
Set frm = Nothing

End Sub-- Arvin Meyer, MCP, MVPMicrosoft AccessFree Access
downloadshttp://www.datastrat.comhttp://www.mvps.org/access
 
Back
Top