Code

Re: Setting the default optional section in a choice group via vba

Caeanis — Tue, 05 Oct 2010 14:33:03 GMT

After fighting with the form for half the night, a much simpler solution tapped me mentally on the shoulder. Get rid of the Choice Group altogether and just use Optional Sections. These work exactly as I wanted. Doh! I'm might be dumb, but I ain't stupid... : )

Re: Setting the default optional section in a choice group via vba

Caeanis — Mon, 04 Oct 2010 21:18:54 GMT

I found that certain objects have a DefaultValue property. I'm wondering for a choice group if there is something like that that can be set programmatically?

Re: Setting the default optional section in a choice group via vba

Caeanis — Mon, 04 Oct 2010 19:12:57 GMT

And additional question is, is there a method or way to determine via vb which section is currently showing? So that if I want to replace that section with another I can create code that first finds out if the section currently showing is the one I want, and if not replace it with the preferred section.?

Setting the default optional section in a choice group via vba

Caeanis — Mon, 04 Oct 2010 18:44:12 GMT

Is this possible? I have 3 radio button group and 3 optional sections, one of which should display when the appropriate radio button is clicked. However only the optional section which is set as the default section shows when it's button is clicked. The others do not. So is it possible on the onclick event for the radio button group to set the appropriate optional section as the default so that it will show? Or is there a way to enhance the rule in place to force the section to become visible?