Option Group

[dhstein]

I created an option group with two buttons. I would like to test the
"optiongroup" value to determine which option was selected, but each one
seems to be an individual control. I can't find a "groupoption" control.
Any help would be appreciated.

 

[Jack Cannon]

Use the Option Group Value - Not the button.

Select Case Me.MyOptionGroup.Value

Jack Cannon

 

[dhstein]

Jack,

Thanks for the response. But I either don't have a group control or
don't know how to get the name. In design view, I can only see properties of
each of the buttons individually. For example, I have control optOption1 and
control optOption2 but no control that seems to be for the group. So I don't
know what the group name is.

 

[Jack Cannon]

If a box surrounds both buttons then click on the box - not the buttons. The
default name of the box is usually "Frame" followed by a number.

If you do not have a common box that surrounds both buttons then it would
seem to indicate that perhaps you created the buttons individually and you
may have to recreate the group.

Jack Cannon

 

[Jack Cannon]

Check the Option Value of each button. Make sure that they are all different.

Jack Cannon

 

[dhstein]

The option values of the 2 buttons are 1 and 2. I am using the Mouse Up
event for each button and that works mostly. Except that the button doesn't
get filled in with the black dot when I select it. So I'm trying to use the
option group the way I thought the option group should work.

 

[Jack Cannon]

Try deleting the text in the MouseUp event.
Use OnClick or AfterUpdate instead.

Jack Cannon

 

[John W. Vinson]

So I'm trying to use the
option group the way I thought the option group should work.

I have no idea where you got that idea but that's not how the option group
should work! Put your code in Frame109's AfterUpdate event instead.