Automatic Current date entry in a record

[Ayat]

Hello,

I have a quick question on how to enter the current date in a record automatically when the record is created.

Here is the situation. Say I have a Products table that lists the products that have come into the inventory. There is a field that denotes the day the product was introduced into the inventory. So ideally when the user creates a new record for the product, I would like this field to be populated automatically with the actual date that this filed was created by the user. Note that in future the user may edit the product (i.e other fields in this record), but the entry_date field should not be altered from what it was the first time is was created.

Is there a way I can do this? Any help much appreciated. thanks.

 

[ghudson]

Create a new [RecordAdded] field in your table. Set that fields Default value to =Now()

 

[Ayat]

confirmation about automatic entry of the current date

thanks a lot.

but I have a question. Based on the Now() function, will this field not be updated everytime the user does something with that recrd. Meaning, if I create the record today, I understand that this function will insert the current date in this field. But what if I open the table a week from now and edit some other fields in this record. Will the date in that field not get updated to the current date because of the Now() function.

My requirement is for the date to be not autoimatically changed once it has been created the first time.

Thanks for your confirmation

 

[ghudson]

Lock the new [RecordAdded] field in your form so that a user can not modify it. The Default setting of =Now() in the design of the table will only be applied on a new record.

 

[Ayat]

that helps. thanks very much

 

[ghudson]

you are welcome