I have tied to close a form without saving the changes using a cancel button. I include the DoCmd.Close acForm "formname" acSaveNo command, but the changes still show after the form closes. I put this in the "ON CLICK" event of my button. It is not set as a cancel button. Any ideas ????

The code for canceling the entry should be:

Me.Undo

That's all you need. But this must be done before going to a new record.

HTH
RDH