View Single Post
  #3  
Old August 25th, 2004, 07:08 PM
Susan
external usenet poster
 
Posts: n/a
Default

Great! And thanks for the prompt response!
-----Original Message-----
1) Create a Date/Time Field in your table. Call

it "AddedOn" or whatever
2) Set "Required" to "Yes" and "DefaultValue" to "Now()"

From this point on whenever a new record is created the

current Date/Time
will be automatically inserted into the field. If you

already have records
in this table you will have to ignore the error messages

you will get when
you save the table the first time. You can fill in

the "missing" data
afterwards with an update query if you desire.

To make it non-updateable on the form: add the field to

the form and then
set the control's Enabled property to False and/or the

Locked property to
True.

--
George Nicholson

Remove 'Junk' from return address.


"Susan" wrote in

message
...
I want to place a field on a form which automatically
indicates the date on which a new record was
created/input. I want this date to be non-updatable and
unchangeable. I'm assuming there must be a field in the
table for this date, but how is it formatted so that the
date the record is input (saved) is the date that is
shown? Is this even possible?



.