Automatically dateadd a date to a from

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

Guest

I have a form based on a table with the fields: "date", "event" and
"attendance". The "event" is a default value on the form and "attendance"
will be manually imput. To facilitate entry and avoid errors I would like to
DateAdd a "date" of one week later automatically in the next new record
"date" field.
 
First, I hope your "date" field is not named date. Date is a reserved word
in Access and can lead to problems.
The solution is to put the following in the Default Value property of you
date field control on your form:

=dateadd("ww",1,date)
 
Back
Top