record Changes in form

[sandrao]

I have a field called "TimeStamp" What I would like is that if someone modifiys or make any change in the form that the "TimeStamp" will record the time and date of change.

How can this be achieved?

sandrao

 

[CraigDolphin]

In the on_dirty event of your form (and assuming you have a textbox called txtTimestamp on the form, which is bound to your field )

Me.txtTimestamp = Now()

 

[sandrao]

The field in question is on the form and linked to each record. What I am finding is that no matter which method I use BeforeUpdate, Afterupdate or on Dirty events the time changes when no changes are made but if a person happens to tab through the form.

Will just tabbing trigger the events?

 

[CraigDolphin]

Tabbing through a form should not trigger the on_dirty event unless someone edits a value in one of the controls. Do you have something in the on_current event that sets the value in a control or something? Tabbing onto a record will fire the on current event and maybe that's what is causing the on_dirty event to fire.

If you could post a zipped copy of your db and tell me which form is generating the problem I might be able to figure out what's going on better.