Default Date and/or Times in Form to Existing Records of Table

  • Thread starter Thread starter boconnor
  • Start date Start date
B

boconnor

Fields are blank in the table. Want the default current
date and times in fields upon entry of additional data in
other blank fields.

How can I set them to default?

Thanks to all in advance.
 
In the design view of the table you can create Default
values for each field.

Date() will give you the current date
Now() will give you the current date and time.
 
Back
Top