Dates - Automatic Entry

[Guest]

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.

 

[Guest]

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.

 

[Rick B]

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

 

[Guest]

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

 

[Guest]

Thanks for your help everyone.