When close a form, do not auto save

[GFullington]

Is there a way to prevent Access from automatically
saving a record when the form is closed?

When the form is initially opened, I am placing the user
at a new record; DoCmd.GoToRecord , , acNewRec.

When exiting the form, I am prompting the user via a
msgbox asking if they want to save the record. If the
user selects "No", I do not want to save the record.

I see one potential solution by deleting the record, but
was looking for a better way without having to delete.

 

[WayneRyan]

G,

You can do a Me.Undo and that will remove the changes, or
you can reference the Me.SomeControl.OldValue property
of your controls.

Wayne

 

[GFullington]

Thanks Wayne, I will give it a try !!!!