M
Mike Collard
How can I requery all controls on a form?
Thanks
Thanks
S
StCyrM
Hi
Try Me.Refresh
Try Me.Refresh
M
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
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
D
Dan Artuso
Hi,
Simply requery the form itself.
Simply requery the form itself.