Arthur Fuller
artful at rogers.com
Sat Jul 9 14:45:56 CDT 2005
I think I have asked this previously, but if I received an answer then I misplaced it. Here is exactly what I need.... This is pseudo-code. Don't expect it to compile! Sub DumpRowSources ( f as Form ) 'assume the form has already been opened by the calling process 'I want to walk the controls 'the only controls of interest are combos or listboxes so I can skip 'over all others Debug.print f.name For Each ctl in f.ControlsCollection '<--- this is the important part If the control is either a listbox or combo-box Debug.print ctl.Name & ":" Debug.print ctl.RowSource End If Next End Sub TIA! Arthur