Results 1 to 6 of 6
  1. #1
    jonesy29847 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Detroit area
    Posts
    43

    PageIndex

    I need to use the PageIndex value of a tabbed form to use for a decision loop, how can I get the value?



    Thanks in advance.
    Last edited by jonesy29847; 11-23-2010 at 10:06 PM.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is the value returned by default when you reference the TabControl.
    Me.YourTabControlName

  3. #3
    jonesy29847 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Detroit area
    Posts
    43
    Ok so how do I use Me.TabName in an if or case statement?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That would depend on what you want to accomplish. All you asked in your post is "how to you get the value".

  5. #5
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I think jones want a sample:
    Code:
    select case Me.TabName 
    case 0
        'first tab is active
     
    case 1
        'second tab is active
    case 2
    case else
    end select

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    jonesy29847:
    Did the assistance provided by weekend00 help? Is this thread Solved yet?

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

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