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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top