Close a Form Without Saving the Data (Access 2003)

Topic

New Reply

Hello,

I am developing a small application with access, and I need to give the user the opportunity to close a form without saving any of the data that they may have already input.

I tried the DoCmd.Close command, but it saves the data.

Any Suggestions.

Reply | Quote

Replies

Access saves the data automatically. How do you intend to determine whether they want to save the data or not when they close the form? A Me.Undo if the form is dirty will roll back the entry, but you would first need to ask the user if he wants to save the data.

Reply | Quote

Access saves the data automatically. How do you intend to determine whether they want to save the data or not when they close the form? A Me.Undo if the form is dirty will roll back the entry, but you would first need to ask the user if he wants to save the data.

Reply | Quote