finding form control names

[Mike]

I need to disable all controls on a form at startup. How can I get this
information from the comands collection using ADO?

[Allen Browne]

ADO will give you access to the fields in the form's RecordSource, but not
to the controls on the form.

Loop through the form's Controls collection, and set the Disabled property
if the control has one: some don't, e.g. lines, command buttons, and labels,
so you will need to use error handling. In general, only the controls with a
Control Source property need to be disabled.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Mike" <mw******@swin.edu.au> wrote in message
news:3f********@news.cc.swin.edu.au...

I need to disable all controls on a form at startup. How can I get this
information from the comands collection using ADO?

[Mike Wharton]

Hi Allen,

Thanks for your reply. Can you tell me what I need to do to loop through
the controls using ADO. I have done this using DAO but want to move onto
ADO.

Thanks for your time again.

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[mail.tpg,com.au]

Hi,

Thanks for your reply. Can you tell me what I need to do to loop through
the controls using ADO. I have done this using DAO but want to move onto
ADO.

Thanks for your time again.
"Mike" <mw******@swin.edu.au> wrote in message
news:3f********@news.cc.swin.edu.au...

I need to disable all controls on a form at startup. How can I get this
information from the comands collection using ADO?