Option Group Issue

[TIG_Slayer]

Hello Forum!

I have a quick question, possibly an easy fix. I currently have a form with an option group with 3 options that have VBA behind them to export certain reports to Excel.

My issue is, that when this form is opened and I select the report to export, and then click the option button, it always runs the second option, no matter which I click. Then after that option executes, I can go back and click the first or third and they will run fine. So this only happens when the form is first opened.



I checked the default values for the option group and it is blank, so i'm thinking it may be an issue since I am running the code when the buttons getfocus?

Any help is greatly appreciated, and if you think something else would perform better, I am open to suggestions also.

Thanks, TIG.

EDIT- Below is a screenshot of what my form looks like.

[ranman256]

Yes set the default value in the frame
and make sure each button also has different value.

[TIG_Slayer]

Yes set the default value in the frame
and make sure each button also has different value.

What should I set the default value to? Once one of the options are clicked, it executes. So if I set the default value to 1, it would execute my first option automatically, which I don't want to happen.
Thanks for the quick reply.
TIG

[ranman256]

You shouldnt execute upon option pick. Accidents happen
you need a button so the user is SURE of the option.
set the frame.value to default.