cancel button

i have created a form with 15 or 16 fields (some of which are text fields, some are radio buttons and someare etc etc...in the bottom of the form i have created , save and save&close and Cancel button.

Suppose when feeding the data in between the fields in the forms and i dont want to save the data... i will press the cancel button. I want when pressing the cancel button, everything should go off (the one entires which i was feeding right now). Even pressing the X button at the top right did not help...

Entring even a single field and pressing the X button, even that entry get saved... that why i have created a cancel buttion.

Anybody can help me with Cancel button. the functionality should be no saving at all.

There is no such thing as cancelling a record once it has been entered. You can use the delete record method to remove an unwanted record that was entered.
lwells

Would the Me.Undo command work? I'm not sure. It will just undo everything on the record right??

Well...I feel a little foolish, you are correct, I had totally forgotten about that.
But it is the same as deleting the record anyway, so it can be called a cancel button.

Here is the syntax

DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70

lwells