Enter todays date on new record entered.

  • Thread starter Thread starter Roberta
  • Start date Start date
R

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
 
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.
 
Back
Top