Adding Certain Number of Days to Date

[infinitx]

Hi,

I have a form that has a textbox that shows a date in the form of 1/19/2005. I want, when the form opens, to add a certain number of days to it. For example, say I want to add 9 days to it, when the form opens, I want the textbox to read 1/28/2005 instead of 1/19/2005. So I want to do: Txtbox1 + Certain # = New Date.

And if I add say 10 days to it, I want the textbox to read 2/1/2005.


Did I explain that clearly? Can this be done?


Thank you very much!

 

[WayneRyan]

infinitx ,

See the Help files for the DateAdd function.

NewField = DateAdd("d", 9, Somedate)

Wayne

 

[Newman]

Change the textbox source to:
=DateAdd("d",CertainNumber,[DateField])

 

[Newman]

You beat me one that one Wayne.
I'll try to be faster the next time.