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

 

[Dale_Fye via AccessMonster.com]

You should just be able to set the value of the tab control to display that
tab, without actually giving it the focus.

Try:

Me.AssocDet.value = 3

HTH
Dale

 

[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