Dates - Automatic Entry

I'm not sure how to phrase this question exactly. I would like to change the
date field in one of my tables so that when I put the date field on my form
it will automatically fill in the current date instead of manually entering
it.

Thank you.

It's called a default value. Open up the table in design view. Click on your
date field. Down towards the bottom in Default Value put:

=Date()

It's important to put it in just like above. Now every new record will have
the computer's date added to the date field. I said "computer's date" as I
have seen some PCs days, weeks, even years off.

If you use =Now() that will put in both the date and the time.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Novice" wrote:

I'm not sure how to phrase this question exactly. I would like to change the
date field in one of my tables so that when I put the date field on my form
it will automatically fill in the current date instead of manually entering
it.

Thank you.

Just set the default in your form for the date field to:
=Date()


--
Rick B



"Novice" wrote in message
...
I'm not sure how to phrase this question exactly. I would like to change
the
date field in one of my tables so that when I put the date field on my
form
it will automatically fill in the current date instead of manually
entering
it.

Thank you.

Thank you.
p.s. nice tag line, lol.

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Thanks for your help everyone.