set default date

  • Thread starter Thread starter Lin Light
  • Start date Start date
L

Lin Light

I have a table with items (books) that we haven't recieved yet.
I have a field called Received Date in that table.
I have created a form where we will call up each title individually by ISBN.
I want to have todays date to automatically populate the "Received Date"
field when we click in that box on the form.
Any help would be greatly appreciated.

Lin
 
Set the DefaultValue for the field in the table to =Date()

Include the equal sign and parentheses.
 

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

Similar Threads

Conditional Formatting 3
dafault value for date not working with Date() but Now() is workin 3
Date of the last time a record was saved 4
Default Value =Date$() in UK Date Format 5
Excel Excel Show Countdown Date 7
Print button on form for single record 3
Date changing in a Form 3
Subforms - Date/Time 2

Back
Top