How do I automatically update a date field.

[jimpeg]

I would like to ba able to automatically fill in the current date whenever I add or update a record on a form. There should be a simple way to do this, but I haven't had any luck yet. I am new to Access, so the more specific the better. Thanks, all.

 

[haj1503]

Go to Design View, Field Date Properties, Tab Data, Go to Default Value, and type like =Date().
i hope this can help u.

 

[tlbroadbent]

Setting the default will only affect the record upon Insert. When you update the record you'll need to Set the date field with DATE().

Update tbl Set TblDate=date()
Where <criteria> Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin