Capturing Changes when form closes

[velcrowe]

I have a form that records when a user edits a record. This change is only recorded when the user clicks the "update record/save" command button. What I need help with is capturing the changes made when a user edits the record in any field and doesn't click the save button upon closing the form. If the user doesn't edit any fields in the record, a new instance of this edit will not be saved to my edited records table and the form just closes

 

[valheru]

Hi Vel

In instances like this where I allow users to edit/update forms i normally disable all input controls until the user clicks edit and then only record the changes once they click update.

In response to your question the simplest way to capture changes to a control is in your form close event to compare what's in the control at the time of the close to what is actually stored in the table for that specific record and then create an event if there is a difference. I assume that if the user closes the form without clicking update that you don't want the changes to be saved but rather to just know whether or not a user did attempt to change the value in the control.

Hope this helps.

Regards

 

[Banana]

Look up Ghudson's Better Mousetrap