DoCmd.RunCommand acCmdUndo

[itwg]

Hey everyone,

I am using DoCmd.RunCommand acCmdUndo to undo changes in my form if the user hits the cancel button. It works great for the main form but it does not work for the subform. How do I undo changes in both the main form and subform on the cancel button?????

Any Ideas,
Itwg

 

[perrymans]

DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70

This is what the wizard provides and works good on both main and subforms.

Me.Undo on the form level may work as well, I don't know about the subform for this one.

Sean