Closing a form problem

[Stigm@t@]

I have found that when closing a form and changes have been made to the fields, these changes will be saved.

I would like to know if there it is posible to only save the changes when a command button is pressed and not when if you close the form any other way.

 

[gemma-the-husky]

do you mean half written changes to the fields on the form. or the form design elements.

if the former, then trap the close form event, or before update event, and pop up a msgbox to confirm save required.

 

[cuttsy]

Look into using unbound forms or catch the before update event of each field.

 

[ghudson]

The forms BeforeUpdate event is the key.

I suggest that you check out these threads for they will help you do what you want...

A Better Mouse Trap?

Enable/Disable The Control Box X Button

Audit Trail