Richard: I keep going back and trying things with this fantastic seminar.  One thing that I was going to mention that I thought was missing was a menu button to allow the current user to change his/her password, username and e-mail address.

So I decided to design one myself using a form based on a query of the UserT with CurrentID () as a criterion.  However, I realized it would be nice to have an exit button where you can ask the user if they want to save their changes upon exiting the form.  My question is: what if they don't want to same their changes? I don't know how to recover the previous data once they have changed the record.  Is this possible?

Thanks

---

Reply from Richard Rost:

It's possible, but it's a bit of a pain. You would need to make your own "close" button because otherwise whenever a user moves to a different record or closes a form, Access saves the data to the table. In your close button, ask the user if they're sure they want to save changes. If so, just close the form. If they say NO, then you can invoke the Me.Undo method which cancels any updates they've made (while the current record is still dirty).