enter current date automatically

[nikki169]

h
i have created a table in access which requires the current date to be automatically entered when a new record is created
can anybody help please? anything will be appreciated, and asap, as this is for a college project due in in 3 days! thanQ

 

[Arvin Meyer]

hi
i have created a table in access which requires the current date to be

automatically entered when a new record is created.

can anybody help please? anything will be appreciated, and asap, as this

is for a college project due in in 3 days! thanQ

Just set the field's DefaultValue property to:

=Date()

That's it! You don't need to even include the field in the form or query
because it will be automatically generated. If you doo put it in the form,
lock the text box so no one can change it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access