A
Adam
I created a conditional macro to set the value of one option box choice to NA
(from Yes, No, NA), if another option box choice preceding it has the value
of No. I placed the macro in the Lost Focus of the Event Tab on the
individual options property sheet (not the option group whose control source
is the field that the value of that option chosen will be stored in). When I
tried to use the control group to accomplish this in the After Update
property on the Events tab i got a different error reading "control is not
available for automation" - any suggestions
(from Yes, No, NA), if another option box choice preceding it has the value
of No. I placed the macro in the Lost Focus of the Event Tab on the
individual options property sheet (not the option group whose control source
is the field that the value of that option chosen will be stored in). When I
tried to use the control group to accomplish this in the After Update
property on the Events tab i got a different error reading "control is not
available for automation" - any suggestions