"Exit" a form?

[snagrat]

I have a form which opens in add mode. On this form is a close button.

When the form is opened and some data is add, clicking the close button doesn't mean that the data is not saved.

The close button just closes the form and the data entered still gets entered into the table.

Is there anyway of creating a command button and using VBA so that when the comman button is clicked it just closes the form and no data is add to the table.

Thanks

 

[Mile-O]

Me.Undo
DoCmd.Close acForm, Me.Name