Results 1 to 3 of 3
  1. #1
    nono5551212 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    11

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

    (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.

    Code:
    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

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

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    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

  3. #3
    nono5551212 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    11
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-03-2014, 03:26 AM
  2. Cannot find Page... where is it looking?
    By That_Guy in forum Queries
    Replies: 3
    Last Post: 08-21-2012, 02:54 PM
  3. Replies: 2
    Last Post: 05-25-2012, 07:36 AM
  4. Find UNC path
    By jordanturner in forum Access
    Replies: 2
    Last Post: 09-17-2010, 09:18 AM
  5. Multiple Control Box on Page
    By nkenney in forum Forms
    Replies: 2
    Last Post: 10-26-2009, 10:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums