I have 2 Option Groups (say OptGrp1 and OptGrp 2), OptGrp1 has a choice of 3 options (1, 2, 3) and OptGrp2 has 2 options (1, 2).
I would like to activate (Enable or Visible) OptGrp2 if and only if OptGrp1 Choice 1 is selected, otherwise the OptGrp2 field must remain "Null"
It must be able to cope with OptGrp1 being altered later, i.e. OptGrp2 must be reset to "Null".
Any clues!!! Should this be a Macro? or some VB?
I would like to activate (Enable or Visible) OptGrp2 if and only if OptGrp1 Choice 1 is selected, otherwise the OptGrp2 field must remain "Null"
It must be able to cope with OptGrp1 being altered later, i.e. OptGrp2 must be reset to "Null".
Any clues!!! Should this be a Macro? or some VB?