ADO to move from one Sub to another

[rringsred]

Hey Thanks a lot. That was it. I have been so tied down in the ASP relm that I forgot how important declaring objects is. Thanks for your help

[rringsred]

Hi,

I am having trouble har coding ADO controls to stay set as I go from one SUB to another. Everytime I start a new SUB I have to reset my hard coded ADo control. For examaple, on an FormLoad Sub I set my control to select all records and from there, depending on which button they press, I movenext or previos, ect. In the button's code I need to reset my connection and my recordset. Do I need to add something to my project or am i missing something really small. Any ideas

Maybe you should check where you declare your recordset. If it is within the Sub then other subs won't see it. Then you should declare it at the form level.