I built a routine that sets a flag to one if the data on the form is dirty.

When the user selects to move to another form I have a message box form that tells the user data had been changed on this form. Do you wish to save those changes?
If he selects yes the flag is cleared and he proceeds to the next form.

If he selects no I have a run macro command that does an undo. The undo is failing. I think this may be because focus had changed to the message box.

I'm not sure how to refocus access to look back at the form and undo what was put in by the user. Any thoughts?

---

Reply from Alex Hedley:

Is this flag a variable in vba or field in the record you are updating?
You shouldn't need to do this. Access handles this itself.
You can do an If (Me.Dirty)

You can use the CONTROL.SetFocus to set focus against a control.