Entering (& locking down) the date that a record was created

[Guest]

Hello,
I want to keep track of the action date (the date that the record was
created). I've tried inserting the =DATE() function, but that doesn't suit my
need as it ends up showing today's date in EVERY record, regardless of when
it was created. I only want it to display the date that the record was
created on. Is this possible to do? If so, I'd then want to lock the field to
prevent the user from changing it (I think I know how to do this...). Thank
you!!!

 

[Guest]

Jennifer,

It your entry appears to be an entry that you would have in a textbox on a
form.

To accomplish what you are wanting to do, open your table in design mode and
make the default value of your field the "Date()" value.

This will only place the current date in the field when a new record is
created, not for every record.