Track change in a form

[jmk909er]

Can anyone tell me how to track when there is a change in a form? I want to have a text box on my form titled "Form changed" and the text box would have date and time. I don't need to track what was changed, just that there was a change. I have already tried "before update" event on the form properties as well as "on data change" using the "Now ()" function.

The "before update" triggers everytime I go to the form regardless if the data has changed or not and the "on data changed" does not seem to do anything. Any help would be appreciated.

Thanks, Joe

[pbaldy]

The before and after update events should not trigger unless something is changed (and one of them would be the appropriate place for your code). Are you sure you don't have code that changes something in the data?

[jmk909er]

Thanks Paul, you know you may be correct and you got me thinking. I did have 2 fields that were auto populating with a name and date created but I got them fixed so that it is only triggered once when the form is created. I will try again

Also what do you think is best to use "before" or "after" update? Everything that I found on the web said to use "Before" but that did not seem right to me???

Thanks for your quick response. -Joe

[pbaldy]

I typically use the before event for validation, since it can be canceled, the after for anything else. Somewhere in the back of my mind (a very cluttered place) is the feeling that updating a value would fail in the before event anyway.

[jmk909er]

Thanks Paul, it is working like a champ now!

[pbaldy]

Happy to help, and welcome to the site by the way! I'll mark this thread solved since it's working now.