dates

[bigmac]

hello all, can you help please ,i have a form with the following fields [calibration date](date field) , [calibration period](number field) and [calibration due date](date field)
what i am trying to do is after the date has been entered into the calibration date field, the user puts the number of months the calibration is for (12 for 12 months 120 for 10 years etc), and then for the calibration due date to update itself to show the calibration date plus the number of months ,
example
[calibration date] = 12/12/2016
[calibration period]=12
[calibration due date] will then show 12/12/2017
can you show me how to achieve this please possibly with an example

 

[arnelgp]

you don't need another field in your table, just compute it on the fly:

your textbox control source:
=iif(trim([calibration date] & "")="", "", dateadd("m",nz([calibration period], 0), [calibration date])