[dba-SQLServer] Walk through the controls on a given form

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




More information about the dba-SQLServer mailing list