how to add date with +1 increment(day)

[goheriq]

i want to add next date automatically
i have two field with name of A and B, my requirement is when i add the date in field A, field B shows me the date with +1increment(day) automatically

what will be the syntax
i am new to access 2007

 

[pbaldy]

The formula you want is DateAdd(), used in the after update event of the first textbox.

 

[goheriq]

Thanks for your time,
Please what will be the complete syntax, if the field names are,
Proddate,
&
Reportdate,

My wish is when I type or insert date in proddate, reportdate shows +1increment every time automatically

 

[Minty]

http://www.techonthenet.com/access/functions/date/dateadd.php

Assuming your Control is called txtReportDate , In the after update event of your prodate control you would need the following code

Me.txtReportDate = Dateadd("d",1,[prodate])