ADO not set error

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????

do you have the exact error message?

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

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