ADO not set error

[rringsred]

Hi there,

I am tweekeing an existing application that used DAO into one tht uses ADO. However, when I make the switch it makes me create a new ADO control every time becaue when I call it from another form it says that ADO is not set, yet it worked fine with DAO. Any suggestions????

[Clunietp]

do you have the exact error message?

[VBfreak]

It might be due to the scope of the ADO object which can't be seen elsewhere than in the form. More details please

[rringsred]

Thanks for the replys. It is greatly appreciated. I The problem is solved but I am thankful for you support