Enter todays date on new record entered.

[Roberta]

Hello,
I want to keep track of the date, when the record is
entered into the system. If new record is entered in the
database, enter the today's date on DateCreated field.

I was thinking writting an if statement on one of the
filds, but each record will be updated each month, and I
don't want this date to be changed each time the record
updated. The only field that will not be updated, is the
Primary key, an AutoNumber field which is hide behind the
form.Writing the if statement on this field didn't work,
because this field is hidden and don't have the focus.

I appreciate any thoughts.
Sincerely,
Roberta

 

[Cheryl Fischer]

Roberta,

In the Design View of your table, go to the DateCreated field. Then, in the
lower left corner of the screen, look at the properties for that field and
find the property labeled "Default Value".

If you want a date and time, enter:

=Now()

If you want just a date, enter:

=Date()

Then save your table's design. As records are entered, Access will
automatically insert the Date/Time (or Date) the record was saved.

 

[Guest]

Thank you, Cheryl.
It was so simple.I never thougt to solve it this way.

Thanks again

 

[Cheryl Fischer]

You're welcome and good luck with your project.