Edit same record twice, SQL Server, ADO

[petermeachem]

I used the vb (6) forms wizard to make a form using ado code. This worked very nicely, and I was able to click up and down the recordset and make changes that were saved ok.
But ...
If I edit a record, go to another, go back to the original and make another change, I get an error message. I can't remember the exact text, something to the effect that it could not find the original record. There were references to the message on MS web, and reams of text, but no actual explanation of how to fix it. I've got over the problem now by explaining to the customer that they really only wanted to edit one record on this form, so I've changed the whole thing.

Does anyone know how to fix this for future reference?
Peter Meachem
peter@accuflight.com

 

[RAtkison]

You might try refreshing the data control.
RKA

 

[petermeachem]

I wasn't using the datacontrol, but selecting the 'in code' option. I tried refreshing the recordset etc, but the only thing that worked as I recall was requerying the whole thing. This is not acceptable as it took too long. Peter Meachem
peter@accuflight.com