How to I cancel and not save the changed data in a form.

[nkenney]

I have a button which goes from on form1 to form2. The user can modify fields on form2. However if the user makes a mistake, I want to provide ta push button where they can leave form2 and not save their data (a cancel and return button). Is this possible?

[RuralGuy]

Me.UnDo will cancel all changes to a form if done before it is saved.

[nkenney]

I appricate it.

[nkenney]

Within my On-Click Code of my close Button I have the following:

Private Sub Command13_Click()
On Error GoTo Err_Close_Form_Click
Me.Undo
DoCmd.Close

Exit_Close_Form_Click:
Exit Sub
Err_Close_Form_Click:
MsgBox Err.Description
Resume Exit_Close_Form_Click

End Sub

It saves the data when it closes. I ran it in debug mode and it encountered this data, I just can not get it to not save. Also I know the close command has a parameter to ask for a prompt. That also does not to appear to do anything (I have been playing around with things today). Any info is appricated.

Thanks,

[RuralGuy]

I suspect the data has already been saved. See if Me.Dirty is true when you get into the Close Button code.