Default value on a form

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I am trying to set the default value for a date field on a form to the day
after the last date already in the table. So when I click to enter a new
record, the date field has the first day that has not already been inputted.
I am sure it is incredibly simple, but I am struggling.

Thanks for your help
 
Try that:
On the default property write the following:

=dateadd("d",1,dmax("dateField","DateTable))
 
Back
Top