"Exit" a form?

snagrat

Registered User.
Local time
Today, 15:51
Joined
Apr 2, 2002
Messages
61
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
 
Me.Undo
DoCmd.Close acForm, Me.Name
 

Users who are viewing this thread

Back
Top Bottom