adding number to date in access form

[buddyr]

Hello,
txtbox one has a date.
txtbox two has a number. number is number of days)
txtbox three is empty.
I have alot more going on but this is my question:
can I add txtbox1 + txtbox2 and show answer in txtbox3?
example:
txtbox1 - 1/2/2008
txtbox - 2
txtbox3 -1/4/2008
thank you

[SonOf27]

Yes you can do that.

[buddyr]

not sure how to do it
do i go into properties of txtbox in control source or do I go into vb code.
Thank you

[SonOf27]

not sure how to do it
do i go into properties of txtbox in control source or do I go into vb code.
Thank you

I guess it depends on what your doing. You could trigger some vb code similar to the following from the after update of the two text boxes to populate the txtbox3 with the answer.

 me.txtbox3 = me.txtbox1 + me.txtbox2 

[Delerna]

Using your naming convention

txtBox3 = DateAdd("m", txtBox , CDate(txtBox1))
 

a better way

txtResult = DateAdd("m", txtMonths , CDate(txtDte))
 

[buddyr]

yes that worked- thank you

[missinglinq]

I've been doing this since the '90s! They keep telling me Date + 3 won't work in the future, but it still does!

Linq ;0)>

[Delerna]

I've been doing this since the '90s! They keep telling me Date + 3 won't work in the future, but it still does!

Linq ;0)>

Yes, and about that time they recommended not using DoCMD for the same reason. But its still there.I don't know about the latest version though.