Date modified

[Lilgreenfrog]

Can somebody tell me of a way to create a 'date modified' field that will update only when the record is actually changed, not whenever it's viewed?

Thanks

 

[Mile-O]

I'll assume you have a field called LastUpdated or something in your table.

In the form's BeforeUpdate() event, put:

Me.LastUpdated = Now

As the BeforeUpdate() event only triggers when the form is Dirty then only when changes are made to the record will the LastUpdated field be updated to the current time.

 

[Lilgreenfrog]

Ahh you're a star

Thanks