Date Update on Form Change

[businessman]

So i have a field called [LastUpdate] that i want to have change to the current date to show when the form was last updated. which event do i use to make this happen and should this be a form event or this field event? I tried using the On Data Change even for the form and then just assigning [LastUpdate] = Date, but that didn't do anything. any ideas?

 

[RuralGuy]

You want to use the Form's BeforeUpdate event which only occurs when something has changed on the record and is being saved.

 

[businessman]

what if i type something and then delete it realizing i tried to correct the wrong record. how do i get the date not to update if my form saves anytime you close it?

 

[RuralGuy]

You could ask the user and do a Me.UnDo if they want to bail out. You can get it as complicated as you want.