Dates in a Table

[TJThompson]

Greetings,

I am making a Database for a local fellow here at work and here is the situation I have ran into.

I am making an Add To Outlook appointment button in a form. What I am WANTING to happen though is this:

I have a control labeled "LastRaise". I am wanting to take the Date that is entered into there, multiply it by 6 months, and then have that outcome in another control labeled "ApptDate". The reason is for the VB code I am using. The ApptDate will be hidden so they won't see it. I am doing this also because I am not TOO famililar with VB or coding for that matter, but dabble in it a tiny. But the LastRaise control will be updated constantly. Now, I want the date to always be shown in the ApptDate field. So I guess that is my question...

What string would I use to calculate that? Would I use

format(dateadd("m",6,DateValue("LastRaise" & "-" & 1 ) ) ,"mm-dd-yyyy")

Or what would I use? That is the only thing I could find. I am sure I am way off.

Also, Where would I put it? I was entering that value into the Default Value section of the control because it would be I guess.

I am just in dire need of some help.

Please!!

-TJ

 

[John Big Booty]

Try putting the following in the After Update event of LastRaise;

Me.ApptDate = DateAdd("m", 6, Me.LastRaise)

PS. Google is a marvellous resource.