Changing the focus on a form

[hdgirl]

I have a form with a command button that has the focus when the form opens, how can i change it so that a combo box on the same form gets the focus on opening?

CJB

 

[BillPower]

Set the Index property of your controls in the order that you want them to get the focus, starting with 0, then 1 etc.

0 will get the focus when the form opens.

Bill

 

[JonoB]

Or, on the form open event, just type

Controlname.SetFocus

 

[ZmrAbdulla]

Hi,
Open the form in the design veiw and select the OnOpen Event of the Form and type the following between the lines

Me.YourComboName.SetFocus

Note: May be your CommandButton has focus already set on the OnOpenEvent. You have to change it.
When you finish your code will be look like below. Make sure to change "YourComboName" to name of your ComboBox.

<-------------*****----------->
Private Sub Form_Open(Cancel As Integer)

Me.YourComboName.SetFocus

End Sub
<-------------*****----------->

BillPower has given another solution.

ZmrAbdulla

 

[hdgirl]

Thanks to JonoB that worked a treat and thanks to all the others that replied

CJB