Using an ADODB Recordset on More than One Form

[quellyn]

My app has one form which displays the results of a multi-table query in a series of textboxes, using an ADO control. I would like the user to be able to cycle through the recordset and make editing changes. What I do is call up a second form with listboxes so the the user can make the changes they want.

Well, the editing form works okay and when I dismiss it and go back to the "viewing" form I can see my changes showing up...but if I exit this form and then try going back in the original data shows back up...so somehow the database isn't getting changed after all. I tried calling the Update method on my adodb recordset, no luck.

Does anyone know what might be up?

 

[woyler]

When you exit the form , then go back to view the data, are you pulling in a new recordset with the updated data, or are you using the existing recordset?

 

[quellyn]

I think that's the problem...I am resetting my global recordset variable to a new recordset each time...

Thanks!