G
Guest
Hello,
I tried your suggestion by adding a field called term_type.
1 = Monthly, 2 = Weekly, and then on my form, I tried to bind it using the
"bind boxing" of the 2 radio buttons. Is that all I need to do to bind them?
I set the default value to =1 which is most common (month).
I also have the input field called "term."
Then, I added in the ControlSource for EndDate:
=DateAdd( Choose( [TermType], "m", "ww" ), [Term], [Acceptance_Date] )
Is gives me the #NAME? error. I think I'm missing a couple of steps still.
Do I need to put it in an Event Procedure.
Also, should I be storing the contract's end date in a main contract table
or calculating it on the form. I do refer to this date for reporting and in
my subform.
Thank you for all of your help!!!
gg
P.S. Initially I was calculating the enddate using this formula and it
worked but not for user entered weeks
Enddate=IIf(DateSerial(Year(DateAdd("m",nz([term_mos],0),nz([acceptance_date],0))),Month(DateAdd("m",nz([term_mos],0),nz([acceptance_date],0))),Day(DateAdd("m",nz([term_mos],0),nz([acceptance_date],0)))-1)
I tried your suggestion by adding a field called term_type.
1 = Monthly, 2 = Weekly, and then on my form, I tried to bind it using the
"bind boxing" of the 2 radio buttons. Is that all I need to do to bind them?
I set the default value to =1 which is most common (month).
I also have the input field called "term."
Then, I added in the ControlSource for EndDate:
=DateAdd( Choose( [TermType], "m", "ww" ), [Term], [Acceptance_Date] )
Is gives me the #NAME? error. I think I'm missing a couple of steps still.
Do I need to put it in an Event Procedure.
Also, should I be storing the contract's end date in a main contract table
or calculating it on the form. I do refer to this date for reporting and in
my subform.
Thank you for all of your help!!!
gg
P.S. Initially I was calculating the enddate using this formula and it
worked but not for user entered weeks
Enddate=IIf(DateSerial(Year(DateAdd("m",nz([term_mos],0),nz([acceptance_date],0))),Month(DateAdd("m",nz([term_mos],0),nz([acceptance_date],0))),Day(DateAdd("m",nz([term_mos],0),nz([acceptance_date],0)))-1)