Record revisions to a record

[kgerlitz]

I would like to have a field in my table that uses the Now() function whenever any field in the record has been revised. Not sure where to start on this one. Thanks for your help

 

[Lilliabeth]

You can put it in the Before Update event of the form. Something like this:
Private Sub Form_BeforeUpdate(Cancel As Integer)
txtLastModified.Value = Now()
Exit Sub

 

[kgerlitz]

Thanks Lilliabeth.

The first run did not work, modified the code to read as below and works fine. I'm not real familiar with this code stuff yet, but know enough to get by on occasion. Do appreciate you pointing me in the right direct.

Private Sub Form_BeforeUpdate(Cancel As Integer)
[txtLastModified] = Now()
Exit Sub