Cancel form entry

[Very Basic User]

I hope this is an easy one. I have a simple form used for data entry. Because
users are not familiar with access, I added a save and close button that
really only closes the form. In the form I have a few required fields, so if
these are not filled out, the user gets several error messages.

What I want to add is a cancel button that simply closes the form without
saving any information that has been already entered and gives no error
messages. This way if a user starts to enter information and either makes a
mistake or decides to not make the entry, they can push "Cancel" and the form
will close without creating a new entry in the table.

 

[BruceM]

In the button's Click event:

Me.Undo
DoCmd.Close acForm, Me.Name

This will clear, then close the form on which the button resides.

 

[Very Basic User]

Perfect! thank you
--
Thank you for your time!
John

In the button's Click event:

Me.Undo
DoCmd.Close acForm, Me.Name

This will clear, then close the form on which the button resides.

 

[BruceM]

You're welcome. Sometimes the answer is nice and simple, which is good for
everyone.

Perfect! thank you