Close all Adodc in one command line?

[Melvana]

Is there any way I could close all my adodc in one
command line? if yes I would really appreciate that
because I have like 35 adodc to close in my application and I don't want to close them one by one.

I hope it's possible...

[Jimbob]

this should do something like what you're after


Dim MyObj As Adodc

For Each MyObj In Controls
'insert in here whatever you want to do to the ADODC
Next


can't think how to do it in one line though....

[P.S.W.]

I didn't think it was possible to "close" an ADODC; they close themselves when the form they're on is unloaded. Let me know if I'm mistaken.

[Jimbob]

I wouldn't know myself. I've not used an ADODC before, but that method is the one I always use for making the same change to many objects