Auto date

Hi Adam

Thank you for your question

I am assuming that you are entering data through a form. If this is the case then you can attatch a dateadd function as the default value of the review date text box.

Bring your form up in design view and select the text box that displays the review date. Then open the properties dialog and go to the data tab

In the Default property type the following


=DateAdd("yyyy",2,[IssueDate])

This is the date add function

yyyy specifies that you are adding years to the date
2 specifies the number of years
[Issue Date] is the field that you are increasing

Hope this helps

Regards

Stephen