View Full Version : listbox requery


casey
05-02-2001, 08:28 AM
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
05-02-2001, 08:45 AM
For Each ctl In frm.Controls
If ctl.ControlType = acListBox Then
ctl.Requery
End If
Next ctl