Auto populate date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning,

I would like to set up a field so that when a user pulls up a form to add a
new record, the date field is automatically populated w/ the current date.
What do I need to do this and what format do I need to set the field to?
Thanks.
 
As posted alll the time (please look for your answers before posting a new
thread), simply make the DEFAULT for the field...

= Date()


The field would need to be a DATE type.
 
Sorry, Thanks for that info.

Rick B said:
As posted alll the time (please look for your answers before posting a new
thread), simply make the DEFAULT for the field...

= Date()


The field would need to be a DATE type.
Click to expand...
 
You must log in or register to reply here.

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

Auto update date in table - not form 9
Auto-populate date field based on two other fields. 7
Auto-populate fields with combo box AND date range 9
Insert Date into Field2, the first Time Field1 is Populated with Dataon Form 2
Default Data in table view 4
Make a Date Field Autopopulate 6
Use VBA to Autopopulate a date field 2
Auto Populate a Field on a Form based on Certain Criteria 1

Back
Top