Adding the Date & Time record added

[jo15765]

I am trying to add the date and time that a record was added to my form, and I first added this to my table, then second on the form, I went to design view, and then right clicked the field and went to properties and set it as =Now() . But when I switch back to the Datasheet view it shows =Now(). What am I doing wrong here?

[pkstormy]

I think what you want to do is set the 'DefaultValue' property of this field to =Now(). If you added a field to the table (such as something called: DateEntered), then on the form you would only want to set the defaultvalue of DateEntered so that only newly entered records will have this field set to the current date/time. If you entered =Now() for the 'ControlSource' property of this field on the form, then you're not storing the value in an actual field.

You'll need to populate existing records with a date/time value or these will be blank.

If after putting in =Now() for the defaultvalue and if it's then not showing the actual date/time as the default for new records, then check your References to see if you have the appropriate Reference loaded (see Reference help for more info).

[jo15765]

I have that set in the default value field. Where is the references?