Save unwanted

[Bigpapou]

Hi all,

When you close a form with the X in the upper right corner Access automaticly save the data, if there is, in the table. How to avoid that?

Tx
Bigpapou

 

[JoeMiller]

If the form is meant to only look at existing you can turn off the AllowAdditions property in the main form. Then the user can't enter in data in a new record to get saved.

Joe Miller
joe.miller@flotech.net

 

[Bigpapou]

Sorry Joe, it's not only a look at form!

 

[JoeMiller]

Then you need to put code in the before update event to check if the record should or shouldn't be saved and code appropriately. You can cancel the update event and inform the user that they can't exit because of the current state of the record. Joe Miller
joe.miller@flotech.net

 

[Francescina]

You should use a variable inside the form that decides whether or not the form may be closed.
Then you check the value of the var in the OnClose event. If it is FALSE, then cancel=true.
You just need to set the var to TRUE in the appropriate close command button.