Requery all controls

[Mike Collard]

How can I requery all controls on a form?

Thanks

 

[StCyrM]

Hi

Try Me.Refresh

 

[Mike Collard]

Apparently it needs a bit more code if the controls are
not bound to the form; which mine are not. A suggested
solution from another formum is

Code to requery all controls

Dim ctrl as Control

For each ctrl in Me.Controls
ctrl.requery
Next

and a simple

On Error Resume Next
will skip controls that can't be requeried

If all your controls are bound to the recordsource, you
can try requerying the entire form:
Me.requery

But if you have independent subforms or listboxes or other
controls, you have to requery each of them

 

[Dan Artuso]

Hi,
Simply requery the form itself.