Frame with 4 Options Button Controls... all selecting

[ilcaa72]

i have attached a pic.

I created a Option Group (no wizard) and dragged 4 option buttons into the frame. If I select any of the 4, they ALL get selected... i want the standard behavior, only 1 option is selectable at a time, so i can use VBA to get the 1 selected (i have the code already)

Can you help me locate the correct setting or how to set this up properly..thanks

 

[MarkK]

Check the OptionValue property of of the radio buttons (on the data tab in design view). I can cause this problem if I put a frame on my form, put radio buttons in the frame, and then set the OptionValue property of each radio button to the same value. Then, if one is selected, since they all have the same value, therefore they all are selected.

To solve the problem, make sure the OptionValue property of each radio button is unique to that button

 

[pbaldy]

Check the Option Value property for each.

 

[sneuberg]

I tried to replicate your situation and the only way I found I could do it was to give the option buttons the same value. I suggest you check the option buttons' Option Values to make sure they are not the same. Typically they would have values of 1,2,3 and 4 for four button. The Option Values are in the Data tab of the option button's properties.

 

[pbaldy]

And I thought I was slow.

 

[MarkK]

Lol.

 

[sneuberg]

And I thought I was slow.

Heh, I had to figure this one out. When I've worked this forum as long as you have I'll be fast too.

 

[pbaldy]

3 people with the same answer = great minds think alike.

 

[MarkK]

I don't usually get a post in ahead of Paul.
Cheers you guys,

 

[sneuberg]

I believe if the bound value of the frame is 0 then none appear selected.

 

[missinglinq]

If you place an Option Group on a Form, back out (Cancel) the Wizard before continuing the creation process, then create and bring Radio Buttons into the Frame, they have no Option Values, at least not in v2007! Is it different in newer versions?

Rather than the Values for each Button being the same, it sounds to me that each Button is Bound to a single Field, which explains why ticking one causes them all to be ticked...the Value of the Field now being -1/True...and all Radio Buttons Bound to that single Field.

As to 'how to set this up properly,' use the Wizard. We routinely eschew the use of the Wizard, in creating Command Buttons, so we can tweak what we're trying to accomplish, but I can't imagine a reason for attempting to do this with an Option Group.

Linq ;0)>

 

[sneuberg]

If you place an Option Group on a Form, back out (Cancel) the Wizard before continuing the creation process, then create and bring Radio Buttons into the Frame, they have no Option Values, at least not in v2007! Is it different in newer versions?

For what it's worth it's different in Access 2013. In trying to replicate the OP's problem I added a Option Group to a form and cancelled out of the wizard. I then added three Option Buttons by clicking in the ribbon and then in the Option Group. They ended up having values of 1,2, and 3. So that process didn't replicate the problem. I had to change the values of the Option Buttons to the same value to get there.

 

[missinglinq]

So you're talking about clicking on the Radio Button then clicking on the Frame...as opposed to 'dragging' a Radio Button (as the OP said he did) from the Form onto the Frame. That does, in fact, work in v2007.

Doing that, the Value assigned to each button does change, increasing by one with each button created. I guess we need to wait for the OP to post back to see how, exactly, he did this.

Linq ;0)>

 

[sneuberg]

So you're talking about clicking on the Radio Button then clicking on the Frame...as opposed to 'dragging' a Radio Button (as the OP said he did) from the Form onto the Frame. That does, in fact, work in v2007.

Doing that, the Value assigned to each button does change, increasing by one with each button created. I guess we need to wait for the OP to post back to see how, exactly, he did this.

Linq ;0)>

I didn't understand where the OP was dragging them from. It didn't make sense to me that he would add them to the form and then drag them into the Option Group but that could be the case. I just tried that. When you add a check box to a form outside an Option Group it's an independent check box with a control source property. Dragging into the Option Group doesn't change that and make it part of the Option Group. If that's what he did then I think having a common control source is the way he would experience the symptoms he was getting.

 

[missinglinq]

The only place you can 'drag' a Control from, best I can tell, if from where it's already been placed on a Form...you can't drag it from the ribbon, like you can a Field from the 'Existing Fields' icon, on the ribbon.

Of course, the OP could have misspoken!

Be nice to hear back from him!

Linq ;0)>