Save Record

[DBFIN]

I have a simple EXIT command button that runs these macro actions: save record, close form. I also have a SAVE command button that runs this macro action: save record. If a user closes the form without clicking either the EXIT or SAVE command buttons, will the record changes be saved in the datasource table.

I have found from testing that the data is always saved even if the user does not click the EXIT or SAVE buttons, but I wanted to be absolutely certain. Is this correct ? Once again, your help and expertise are always greatly appreciated.

 

[CJ_London]

If a user closes the form without clicking either the EXIT or SAVE command buttons, will the record changes be saved in the datasource table

Subject to anything you have in the beforeupdate event for the form, the answer is yes

If you don't want the user to exit this way, then change the Form Close button property from yes to no. If you do this then you will need another button to exit without saving otherwise the user will always have to save in order to close the form

Also be aware that if your form has subforms then when the user moves from the main form to the subform, an update event will be triggered