re-setting option groups

[CJG via AccessMonster.com]

I have 10 yes/no option groups which work fine, however I would like to be
able to re-set my anwer so neither of the options are selected. Is there a
simple way to do this? Currently I have created a macro for each option
group which I have on the On Dbl Click Event....this seems alittle over board.
....any suggestions?

Thanks,
CJG

 

[Jay]

Not sure what version you're using, but I think you can adapt this to
whatever version you're using.

I'm assuming you're using checkboxes for the Yes/No. I would create a
command button and set the values to all the checkboxes to false. I believe
the code (in Access97 anyway) is:
chkSomeCheckBox.Value = False

Someone else might have a better idea.

Jay

 

[Klatuu]

If you want neither option to be set, then you should set the Default Value
property of the option groups to nothing (I mean no value in the box where
you put the defalut). Then when you want to set them so that neither is
selected:
Me.SomeOptionGroup = Null