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

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.
 
B

Bish

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.
 
Top