Option Groups

[Jkittle]

I have created an option group on a form. Is there a way to change the check boxes so they toggle on and off?

 

[KenHigg]

Do you mean you want a group of check boxes to be mutually exclusive - only one can be selected at a time?

???
ken

 

[Jkittle]

No. I have an option group of about 15 choices and you can only select one. But I would like to be able to turn them on and off. If you accidentally select one you can't uncheck them right now. There are times when you won't check one.

 

[KenHigg]

No. I have an option group of about 15 choices and you can only select one.

You've lost me. How can you say no and then repeat what I just said?

Do you want it like this (To be able to select only one), or do you want to be able to select any combination of check boxes and turn them off or on?

 

[Rabbie]

Do you want to have them all switched off?

 

[missinglinq]

So, if you accidentally check one, and you want to send it back to a state where none are checked? If this is right, you can use a "reset button" to set the value of the field tied to the Option Frame back to Null. Call the command button ResetOptionGroup:

Private Sub ResetOptionGroup_Click()
  Me.YourOptionFrame = Null
End Sub

 

[Jkittle]

I'll try to explain it better. In an option group you can only select one option and that part works and is what I want.

However, once you have selected an option check box you can not uncheck them. You can check another option but you can not go back to all option not checked and that is what I want.

In my database there may be records that do not have to have one of the options checked and I need a way to uncheck a check box with deleting the whole record.

 

[KenHigg]

So it will let you check an option but won't let you uncheck it? That is odd....

 

[Jkittle]

Yes, that's it. Once selected you can not uncheck. I've looked in properties for a toggle on/off but can't find anything.

 

[KenHigg]

Do you have the in a frame (option group) object? Not that it would matter for any reason I can think of - just curious...

Eidt: I just tried this - Putting a check box in a frame (option group) and it wouldn't let me uncheck it so maybe that's your problem. Don't put them in an option group.

 

[missinglinq]

Look at Post # 6! Doesn't this address your problem?

 

[Jkittle]

Option Button Works

missinglinq,

Thanks!! Your code worked.

Jerry

 

[Jkittle]

Ken, Thanks for your help

 

[missinglinq]

Glad we could help!

Linq