Charlotte Foust
cfoust at infostatsystems.com
Tue May 31 17:36:54 CDT 2005
ADO doesn't know about controls, Arthur. You should be able to use DAO code, even in an ADP, for that purpose. Charlotte Foust -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Tuesday, May 31, 2005 3:32 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Walk through the controls on a given form I'm asking here because I need this to be ADO code not DAO. I already have a For Each loop that walks all the forms in an ADP. Now I want to add to this a call to a sub that walks the collection of controls on the given form and looks at combos and listboxes, printing their rowsource. Anybody got a chunk of code like that? TIA, Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com