automatic 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
 
R

Rick B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top