PageIndex Property

[rfear]

Can I specify which tab is in view when my form opens ?

At the moment the tab I want users to see is not the one MSAccess chooses to show.

Can I use something like "me.pgGeneral.PageIndex=5". This does not work by the way to specify the tab that is in view when the form opens.

I don't want to change the order of the tabs, I don't fancy modifying any tab indexes now the form is designed.

Do I have any other options ?

 

[MSAccessRookie]

Can I specify which tab is in view when my form opens ?

At the moment the tab I want users to see is not the one MSAccess chooses to show.

Can I use something like "me.pgGeneral.PageIndex=5". This does not work by the way to specify the tab that is in view when the form opens.

I don't want to change the order of the tabs, I don't fancy modifying any tab indexes now the form is designed.

Do I have any other options ?

I think that you can set the focus on the Tab that you want to see first in the "On Open" Event for the Form.

Adding something like Me.{TheFirstTabIWantToSee}.SetFocus should get you what you want.

 

[rfear]

Me.cmdPaybackGroup.SetFocus

works a treat where 'cmdPaybackGroup' is a control on the tab I want to see first.

Sorted - thanks.

 

[missinglinq]

Remembering that the page index is Zero-based, you could also use one of these

Me.TabControlName.Value = 0 'First page
Me.TabControlName.Value = 1 'Second page
Me.TabControlName.Value = 2 'Third page

depending on which page you want to see, in Form_Load if you're only concerned about which page shows when you first open the form, or in Form_Current if you always want to see the same given page when you move to another record.

Of course you have to replace TabControlName with your actual control name.