Undo in form and subform

[azhar2006]

Hi All
I have a form, for example Customer, that contains an embedded subform, for example Addresses. I have a Cancel/Undo button on the main form. I understand that clicking in and out of the subform will automatically save the record. I've seen that using "DoCmd.RunCommand acCmdUndo" will undo the saved record on the main form while "Me.Undo" does nothing. I've also noticed that the subform record is not undone. What I've read is that the subform record must be deleted. However, that is not an option when the user is modifying an existing record. How can I revert the subform record .
Thank you

[June7]

Maybe save the data to variables declared publicly in the module header (or use TempVars). And if user choses to undo, reset the field values to the variables.

[azhar2006]

Thank you June
I use this code

If varResponse = vbNo Then
Me.Undo
SendKeys "{ESC}"
SendKeys "{ESC}"
Exit Sub
End If

But I want it implemented through button
How?

[June7]

Don't understand. If you want the code behind button then create the button and put the code there.

That code won't do any good if the record edits are already committed to the table.

[azhar2006]

Yes, this is exactly what I want
One button doing a retreat for the master and sub ​​in that one
want the code behind button then create the button and put the code there.

[ItsMe]

There is a difference between "DoCmd.RunCommand acCmdUndo" and "Me.Undo"

DoCmd will execute on the object that has focus and the Me shortcut will reference the object that owns the module. In other words,

Me.Setfocus
' Docmd here will reference the same object as the Me keyword
DoCmd.Close

Me.MySubform.SetFocus
' Docmd here will reference the SubForm object
DoCmd.Close   'will cause an error because the Close method is unavailable to subform objects

[azhar2006]

Thank you ItsMe
Is it possible to clarify the code more
Where do I put those events

[ItsMe]

The code would be most beneficial to simply read and interpret. the code does not really serve a function within an application. If you look at the code, you may understand why your Docmd works sometimes and does not work other times.

Another point to make is, the Undo method is not always dependable because Access may commit a field/record without the user recognizing that the data has been saved. Linked subforms behave a certain way. It takes time to test your form(s) and understand their behavior.