Question Date Field

[Jeff Wilkinson]

I have a database where I have 2 simple fields. 1 is called ISSUEDATE and the other is called EXPIRATIONDATE. How can I make the EXPIRATIONDATE automatically show a date 13 months away from the ISSUEDATE?

 

[pbaldy]

I wouldn't store something if the period was fixed, but you'd use the after update event of the first textbox to set the second, using the DateAdd() function.

 

[Privateer]

this will add 13 months to the issue date
me.expirationdate.value = dateadd("m",13,me.issuedate.value)