Requery ALL controls on form

N

nFaux

Is there a way to requery ALL the controls on a form without having to
identify each individual control in the DoCmd.Requery "ControlName"?
 
A

Arvin Meyer [MVP]

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
 
Top