Dateserial Expression in Text Box using Values From Two Controls

[MintChipMadness]

Hi Everyone,



I am having an issue putting an expression in a text box on my form. I listed the two controls I am using and the expression below them. I am setting the Control Source as the expression. I did some trouble shooting by putting the text box just equal to the first control and then to just the second one. They show the correct values individually but when I put them in the expression they don't work. I did find out that the part where it goes wrong is at the addition. How I found that is I took out adding of the second control all together and it came out with the correct date. All I am trying to do is add a number to the amount of years and display it. Thank you for your help.


Control #1 (Text Box): [recordfye] = date
Control #2 (Combo Box): [catcbo] = number

DateSerial(Year([recordfye])+[catcbo],Month([recordfye]),Day([recordfye]))

[MintChipMadness]

I figured out what my error was. I should have used a period instead of an exclamation point in between the column and control of catcbo. The correct expression is below.

DateSerial(Year([recordfye])+[catcbo].[column](6),Month([recordfye]),Day([recordfye]))

The expression below worked as well

=DateAdd("yyyy",[catcbo].[column](6),[recordfye])

[RuralGuy]

Thanks for sharing your solution!