Date Stamp for when record is created

[davidrsutton]

Hi, here is a nice and easy one for you guys (hopefully!)

I have a field called 'CreationDate' in a table called 'tblIssues'. I want the 'CreationDate' field to contain the date that that particular record was created on and I want to lock the field so that it cannot be edited/deleted.

I can make it so that the user hits a button on a form and it populates the 'CreationDate' field but I would ideally like this automated so that it happens when the record is created.

Many thanks in advance,

Dave

 

[Remou]

Have you looked at setting the default value in the table to Now() or Date()?