Automatically Update "lastupdate" field

[Porthale]

Hi folks

Really could use some help here, I have an access 2000 database, I need
it to automatically add a date to the "lastupdate" field when a record
is modified.

Any help would be greatly appriciated.

I can email the database if needed.

Cheers
Darren

 

[Allen Browne]

Access cannot do this for you at the table level.

If all records are modified through a form, use the form's BeforeUpdate
event procedure to write the date:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[lastupdate] = Now()
End Sub