Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2005
    Posts
    44

    Unanswered: referencing tabs

    Is it possible to reference to a particular tab on a form?

    for example i would like to create a button which allows the user to open a form on a particular tab

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    The only way I know of to do that is to open the form and set the OpenArgs parameter to the page number you want to default to. In the form you are opening you will have to look at Me.Openargs and move to the page that was specified.

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    I'm assuming by opening a Form on a Tab you mean a SubForm in a Tab...

    To open a particular Tab you can use the following within the OnClick event of your Command Button:

    Me.myTabControlName.Pages(1).SetFocus

    Tabs are referenced from left to right as 0, 1, 2, 3, etc. The above example will open the second Tab of the Tab Control named myTabControlName.

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    referencing tab control

    or for a tab control...

    Select case me!tbcntrl
    case 1
    me!mySubFrm.sourceobject = "someformname1"
    case 2
    me!mySubFrm.sourceobject = "someformname2"
    case 3
    me!mySubFrm.sourceobject = "someformname3"
    end select

    But you probably want to use the On Change property for the code above.
    Last edited by pkstormy; 03-24-06 at 11:42.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •