Two option groups on one Form...

[themanof83]

Hi,

I am trying to use two options groups on one form, but I do not want to be able to select an option from each group.
If a selection is made in one group then I want to ensure that any selection that may have been made in the other group is removed without disabling the group entirely and vice versa. I need both groups to function but cannot have selections made at the same time....

Thanks in advance!

 

[KenHigg]

Put something like the following in the click event of each option frame:

In frame1:

Me.Frame2 = ""

In frame2:

Me.Frame1 = ""

 

[themanof83]

Bingo,

Cheers Ken

 

[missinglinq]

Just out of curiosity, if you only want one selection possible from the two groups, why the need for two groups?

 

[themanof83]

Very different criteria, clever/efficient use of form etc.........

 

[KenHigg]

Glad it worked - Have a good day