How Can I Find The Path To A Tab Control Page?

[nono5551212]

(ACCESS 2013)



Hello,

I have code from another DB that works... But I'm making a new DB and instead of a subform I used the Tab Control.

I guess my question is... What is the path to my PAGE1

NEW DB DETAILS
Table: T_Customers
Form: F_Customers
Tab Control Name: Tabs
Page Names: Page1 & Page2

On the F_Customers form I have a tab control with two pages.. PAGE1 & PAGE2

Using the code below what is the proper path to my PAGE1 on my TAB CONTROL.

Private Sub Item_Click()
    With CodeContextObject
        If (IsNull(.ID)) Then
        Exit Sub
        End If
        DoCmd.BrowseTo acForm, "PWD_Password_Form", "PWD_Main.PWD_Password_Form", "[ID]=" & .ID, "", 1
    End With
End Sub

This is the line I need to change. This code was from the old DB

DoCmd.BrowseTo acForm, "PWD_Password_Form", "PWD_Main.PWD_Password_Form", "[ID]=" & .ID, "", 1

[John_G]

Hi -

On a tab control, each tab has an index value. In design view, click the tab and open the properties sheet to see what they are.

In form view, to move to a specific tab, set the tab control to the index value for the tab, e.g.: me!Tabcontrol = 2

HTH

John

[nono5551212]

I am kind of new to access.. I have created a screenshot to better explain what I am trying to do..

I'm hoping you can post the code and I can just cut an paste it into my DB.... I am not that familiar with vba..

Thanks

http://s7.postimg.org/wfawysc57/form.jpg