Date month calculation based on combo box

[wnicole]

I want to set the due date based on a drop down menu/combo box.


Ex: the length of time product date expiration is based on set list:

So we have acquired date: 5/1/2013
Then due in drop down: One month, 3 months, one year, etc

I need to set the due date automatically based on selection in combo box.
Does this required an iif statement? Or is there a better way?

[June7]

Yes, that would require a long nested IIf expression to calculate the due date. If you instead saved the period in months (1, 3, 12) then calculating the due date would be simply DateAdd("m", [Period], [Acquired]).
You could set up the combobox so users see the descriptor but the months will be saved.

[wnicole]

Yes I like that idea.
I will change to numbers that makes it easier thanks june7

[wnicole]

Everything worked fine...Im using
=DateSerial(Year([Calibration Date]),Month([Calibration Date])+[Months],Day([Calibration Date]))
However, when the Date field is null I get this: #Type!

Anything I can add in this code to maybe just leave blank if date is missing?

[June7]

Why are you using DateSerial instead of just DateAdd? If [Calibration Date] is Null then the expression will return Null.

= DateAdd("m", [Months], [Calibration Date])