Tab Visibility

[LDMueller]

In Access 2003 I have a single form which has various combo boxes. At the
top I have a tab control with five buttons.

When a user opens the form, they see the detail on the first tab. As they
go through the form making selections on each combo box, when the get to the
4th combo box I want the 3rd tab to be showing it's detail, but I don't want
the cursor to be on the tab.

This is what I’m working with:
Main form: Single page
Tab/Page -Name: AssocDet; Page Index: 3

Below is my code and it works fine except I want the cursor to remain on the
combox box.
Private Sub Productivity_GotFocus()
Me.AssocDet.Pages(3).SetFocus
End Sub

Thanks,

LDMueller

 

[Marshall Barton]

In Access 2003 I have a single form which has various combo boxes. At the
top I have a tab control with five buttons.

When a user opens the form, they see the detail on the first tab. As they
go through the form making selections on each combo box, when the get to the
4th combo box I want the 3rd tab to be showing it's detail, but I don't want
the cursor to be on the tab.

This is what I’m working with:
Main form: Single page
Tab/Page -Name: AssocDet; Page Index: 3

Below is my code and it works fine except I want the cursor to remain on the
combox box.
Private Sub Productivity_GotFocus()
Me.AssocDet.Pages(3).SetFocus
End Sub

Try using:

Me.AssocDet = 3

 

[LDMueller]

Thank you so much. That was exactly what I needed.

LDMueller