The new 4th option will be selected. If the control source is character, the option button prompt will be stored instead.
However, 10 options is really too many. Perhaps a drop down list is more appropriate from a UI design standpoint. Although, you'll still have the same problem.
>I have an option group that had 9 options. They were arranged on the form from option1 to option9 and listed in the property sheet from option1 to option9. Now I need to add a new option and it must be on the form between option3 and option4. How does the ControlSource play into this? If the controlsource is set to 4, it is selecting the 4th option listed on the form, or the 4th option listed in the property sheet. My controlsource is not working as expected and I am confused.
>
>Brenda
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer