auto add last modified

  • 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
 
Hi:

If updates are done via a form you could trap the Form_BeforeUpdate event
and write code like this --

Me.DateLastUpdate = VBA.Now()


This assumes you have a Date/Time field called DateLastUpdate in the table
bound to form.

Regards,

Naresh Nichani
Microsoft Access MVP
 
Back
Top