listbox requery (1 Viewer)

casey

Registered User.
Local time
Today, 13:31
Joined
Dec 5, 2000
Messages
448
Does anyone know of a easy way to requery all the listboxes on a form? I'm having difficulty writing all these requery statements and would like to know if there's a simplier way to do it.
BTW:The "refresh" method is not what I needed. Thanks
 

charityg

Registered User.
Local time
Today, 13:31
Joined
Apr 17, 2001
Messages
634
For Each ctl In frm.Controls
If ctl.ControlType = acListBox Then
ctl.Requery
End If
Next ctl
 

Users who are viewing this thread

Top Bottom