Date/Time help

[mate]

I have users create new records in a subform. I want the
date and time that the record was created to show up
everytime that record is viewed. Everytime i go into a
record, the current date/time is shown instead of the
date/time it was created. Is there any way to do this?
Any help would be super. thanks, mate.

 

[John Spencer (MVP)]

If you don't have a field in the table to store the datetime, then add it.

Set its default value to Now()

The field will automatically store the time of record creation. If you want to
display it, then add a control to the form (subform) to show it and set the
control's locked property so user's cannot edit the control.