Automatically Update "lastupdate" field

  • Thread starter Thread starter Porthale
  • Start date Start date
P

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
 
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
 
Back
Top