Hello -

I'm new to VBA and have a problem with a form which contains several
frames. In some of the frames I have sets of option buttons. Each
set has an option selected by default. When I run the form, the first
time I select a different option button in any of the frames, the
group of options in that frame are all deselected, including the
default option. If I click the same choice a second time, the correct
option gets selected in that frame.

If, however, I first make a change to one of the text boxes in a
different frame, and then select an option button, I don't encounter
the odd behavior with the option buttons. What am I missing?

Thank you.

You probably want to add an initialize function to the form to run the first
time and set the default options.

"skoalnreds" wrote:

> Hello -
>
> I'm new to VBA and have a problem with a form which contains several
> frames. In some of the frames I have sets of option buttons. Each
> set has an option selected by default. When I run the form, the first
> time I select a different option button in any of the frames, the
> group of options in that frame are all deselected, including the
> default option. If I click the same choice a second time, the correct
> option gets selected in that frame.
>
> If, however, I first make a change to one of the text boxes in a
> different frame, and then select an option button, I don't encounter
> the odd behavior with the option buttons. What am I missing?
>
> Thank you.
>

On May 29, 8:39*am, Joel <J...@discussions.microsoft.com> wrote:
> You probably want to add an initialize function to the form to run the first
> time and set the default options.
>
>
>
> "skoalnreds" wrote:
> > Hello -
>
> > I'm new to VBA and have a problem with a form which contains several
> > frames. *In some of the frames I have sets of option buttons. *Each
> > set has an option selected by default. *When I run the form, the first
> > time I select a different option button in any of the frames, the
> > group of options in that frame are all deselected, including the
> > default option. *If I click the same choice a second time, the correct
> > option gets selected in that frame.
>
> > If, however, I first make a change to one of the text boxes in a
> > different frame, and then select an option button, I don't encounter
> > the odd behavior with the option buttons. *What am I missing?
>
> > Thank you.- Hide quoted text -
>
> - Show quoted text -

Hi - thanks for the response. Your suggestion did not make a
difference. Anyway, the default values are stored in a spreadsheet
and they are linked as the control sources to the appropriate
objects. When the sheet is opened, the correct defaults are already
selected.