<div>
From the Access Help File:<br />
<br />
&quot;The Value property of a tab control contains the index number of the current Page object. There is one Page object for each tab in a tab control. The first Page object always has an index number of 0, the second has an index number of 1, and so on.&quot;<br />
<br />
If you wanted to know everytime tabs are changed, put code in the Change event for the Tab Control.<br />
<br />
Private Sub TabCtl0_Change()<br />
&nbsp; &nbsp; MsgBox &quot;Changed to Tab &quot;&nbsp;&amp; TabCtl0.Value<br />
End Sub<br />
<br />
Regards,<br />
<br />
Idle_Mind
</div>


From the Access Help File:

"The Value property of a tab control contains the index number of the current Page object. There is one Page object for each tab in a tab control. The first Page object always has an index number of 0, the second has an index number of 1, and so on."

If you wanted to know everytime tabs are changed, put code in the Change event for the Tab Control.

Private Sub TabCtl0_Change()
    MsgBox "Changed to Tab " & TabCtl0.Value
End Sub

Regards,

Idle_Mind

<div>
Hi !<br />
<br />
Thanks for your reply...I tried the damn thing and it didn't work and now it's ok...Oh well !<br />
Can you also answer this easy question : how do i select programmatically a tab using this value ?<br />
<br />
Thx
</div>


Hi !

Thanks for your reply...I tried the damn thing and it didn't work and now it's ok...Oh well !
Can you also answer this easy question : how do i select programmatically a tab using this value ?

Thx

<div>
Many thanks for your help :)
</div>


<div>
<div class="content wysiwyg-content">
Hi !<br />
<br />
I have a standrad tab control in one Access form. How do &nbsp;i get the index, or name of the selected (active) tab ???<br />
<br />
Thanks !
</div>
</div>


Hi !

I have a standrad tab control in one Access form. How do  i get the index, or name of the selected (active) tab ???

Thanks !

Getting active Tab

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.