Timestamp for table field

[wilf123]

Dear experts,

I would like to have a time stamp for each record showing the creation time/date of the record.

When following the description:
office.microsoft.com/en-us/access-help/add-a-date-or-time-stamp-to-new-records-HA010235849.aspx

the outcome is, that each record shows the creation time/date of the record created before, which is not exactly what I want.

I know this can be handled on form level (in the AfterInsert event), but I think it would be more elegant on table level. (Because obviously it has to be done in every form if there are multiple forms for the same table, and I it wouldn't work if somebody bypassed the form)

Am I missing something?

Thanks in advance, W

 

[Mile-O]

Is it not enough to set the Default Value of the field to =Now()

 

[wilf123]

Is it not enough to set the Default Value of the field to =Now()

Thanks for your reply, but the result is that each record shows the creation time/date of the record created before.

Please look at the screen shot, to see what I mean. When inserting record with ID 14, the time stamp for the next record is already created. Not sure why it is done this way.

Thanks in advance, W

 

[jdraw]

I think that is showing you the default value for the next record if you choose to create the next record.
If you look at record ID 2 you'll see the timestamp is persistent.