Automatically dateadd a date to a from

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

Guest

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)
 

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

Using Form to input multiple field to table at once 1
Set Date Value to previous day of current day 2
duplicate values 2
New Form 5
Date Add Function on Forms 1
Date Field Update Based on Start Date 1
Default value on subform 4
main form based on table with no date field-need to tie-Sun dt w/s 2

Top