Help with Undo command

[BCarruth]

I am trying to undo changes to a subform's record (not delete the record just undo the changes). I have a button on the mainform called Undo my code behind it is as follows:

Private Sub UndoButton_Click()
Me.Undo
Me.sfmOrderDetailsSTATUSCONTROL.Form.Undo
End Sub

sfmOrderDetailsSTATUSCONTROL is the subform control name

When I click the button I would like both changes in the main form and subform to be cancelled.

Thanks for the help
Bob

 

[THoey]

I haven't used this before, but I looked in the help and it looks ok. Do you need to do a refresh or a requery to see the initial records? Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.