Activate 2nd option group from 1st option group (1 Viewer)

[EricH]

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?

 

[charityg]

optgrp1 afterupdate
if optgrp1=1 then
optgrp2.visible=true
else
optgrp2.visible=false
optgrp2.value=null
end if

also put this code in the on current event of the form
I'm not sure if setting optgrp=null will work, but you can try.