Followup on CancelUpdate-Help!

[Thom]

After a little more research-the problem only seems to be happening when I create a NEW test and while EDITING a questions I change my mind & hit the UNDO it deletes! Here's the code:

First the EDIT record code:

Case cmdEdit '-- edit the current record
editStatus = nowEditing

With rs1
vMyBookmark = .Bookmark
Me.Caption = "Editing this Item"
End With

This sets the bookmark to the CURRENT record..

Then, I hit the UNDO cmdbutton:

Case cmdUndo '-- undo changes to the current record
With rs1
If editStatus = nowEditing Then
.Bookmark = vMyBookmark
End If

.CancelUpdate [HERE's where the DELETE occurs!]

If (Len(vMyBookmark)) Then
.Bookmark = vMyBookmark
Else
If .RecordCount > 0 Then
.MoveFirst
End If
End If
End With

editStatus = nowStatic

Now this works just fine if I ADD & then Undo, but NOT if I edit!! Any ideas why?? I'm using ADO 2.1, but the PC has MDAC 2.5 installed in order to put SP4 for Visual Studio on it-could that be part of the problem??