Undo changes in each record upon exit 2

[Hinfer]

I have a form that displays all the current 5 employees. How do I create a button so that I can exit the form and not save the changes. The problem is that each row is a record.

DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_UNDOFIELD, , A_MENU_VER20
DoCmd.Close A_FORM, "LkEmployees"

If I have changed 2 records then this will only undo the last record that I changed.

Is there some way to undo the changes in all the records. Access seems to save automatically when I move to different records. Can I disable this or is my code wrong?

I have tried Docmd.Close, , acsaveno but this again works for the last record changed.

 

[TTThio]

Yes Hinfer, I can take a look at it.
Email me at tin.tin.thio@terabeam.com