automatic date

  • Thread starter Thread starter dwayne
  • Start date Start date
D

dwayne

I have a "Last Update Made On" field which is an input the
user has to enter whenever any changes or entries are made
to any field in the record.

Is there a way to have the date automatically change to
the current date whenever a record is entered or ammended?

Thanks,
Dwayne
 
Yes,

Just build some code in the form's "before update" and/or "before insert"
event that says...

[LastUpdateMAdeOn] = Date()



By the way, I would never use a space in a field name.

Rick B
 
Back
Top