combo box value

[joanne21]

Based on the value of a combo box, I want to make the corresponding tab page in a multi-tabbed box have the focus. This should not be difficult but I appear to be missing something.

[code]
Private Sub cmdDetails_Click()
If Me.cboCatmain.Column(0) = "2" then
Me.Trucks.SetFocus
End If


End Sub

[amrut]

Me.YourTabControlPageName.SetFocus
I think "Trucks" is your label for that page.

[ssanfu]

Is Me.cboCatmain.Column(0) a number or a string?

The number 2 is different than a string "2" (with quotes)

Might also look at
http://www.dbforums.com/microsoft-ac...using-vba.html

[joanne21]

Me.YourTabControlPageName.SetFocus
I think "Trucks" is your label for that page.

Thanks, it works