enable/focus in form_load

[ober0330]

Combo0.Enabled = True
    Combo13.Enabled = True
    Combo0.RowSource = "01;02;03;04;05;06;07;08;09;10;11;12;"
    Combo0.SetFocus
    Combo0.Text = Format(Now, "mm")
    Combo13.RowSource = Year(Now) - 1 & ";" & Year(Now) & ";" & Year(Now) + 1 & ";"
    Combo13.SetFocus
    Combo13.Text = Year(Now)
    Display_Report.SetFocus
    Combo0.Enabled = False
    Combo13.Enabled = False

There has to be a better way to do this. I want the form to start up with values in the combo boxes but I don't want them to be enables unless the user clicks a different option button.

I had to do the setfocus enable/disable routine just to get it to work... unless there is a better way?!

[Avatarp]

dont use the .Text property of a combo box.

Combo0.Text = Format(Now, "mm")

becomes

Combo0 = Format(Now, "mm")

[ober0330]

Sweet... next question... I have 3 options in an option frame, but when I open the form and click on another option, it won't go to it. It will execute the code, but the option will not be selected.

??

[Avatarp]

get rid of the setfocus statements

[ober0330]

I did that. I had to do it that way to get it to work the first time.

[Avatarp]

each option button should have its own value which is reflected in the Frame's value property

[Avatarp]

the wizard helps a lot when setting up options groups

[salvelinus]

Omitting the default property (i.e. text) of a control when you reference it is also a little faster.

[ober0330]

OK, well I got the stupid thing figured out. I was setting the focus to the option to get around the problem of the error I posted before. As soon as I took all those out, it worked fine