date field

[Guest]

I would like to have a date field in a form that with auto the date of the
form was created and then hold that date for inquiries. Can this be done.

 

[Al Campagna]

Mike,
Add a field to your table called somthing like DOC (aka Date of Creation).
Place that feild on your form, and give it a Default Value of...
= Date()
Whenever a new record is created, DOC will be set to the current system date.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Would the date created stay on that form So if I create a record on tuesday,
and I printed a reort on Friday would it still show that tuesday was the date
it was created?

 

[BruceM]

Default value applies only to new records, so it will not change the date on
an existing record.