How do I reference the controls on the individual pages of a "tab" control

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • smith1966
    New Member
    • Mar 2008
    • 3

    #1

    How do I reference the controls on the individual pages of a "tab" control

    Please Help ...

    I need to reference a particular control that exists on a "tabbed" page
    eg
    TABCtl5 has 3 "pages"
    I have focus set to "TABClt5(Pa ge-1)".
    I need to access the content of a "text box" (named control-A) on "Page-3"

    Within VBA ... How do I access access "Control-A" on "Page-3".
    If I have focus set to "Page-1" ?

    Thanks In Advance ...
  • PianoMan64
    Recognized Expert Contributor
    • Jan 2008
    • 374

    #2
    [CODE=VB]
    me.[Control A].Value 'If there is a space between the word Control and A
    me.ControlA.Val ue 'If there is no spaces between the word Control and A
    [/CODE]

    All values on the form are available to you anytime. Just simply reference them by using the me.controlname. value or shorthand me.controlname

    Hope that helps,

    Joe P.

    Comment

    • smith1966
      New Member
      • Mar 2008
      • 3

      #3
      perfect ... thanks
      Task is now working as expected ...

      Comment

      • ADezii
        Recognized Expert Expert
        • Apr 2006
        • 8834

        #4
        Originally posted by smith1966
        Please Help ...

        I need to reference a particular control that exists on a "tabbed" page
        eg
        TABCtl5 has 3 "pages"
        I have focus set to "TABClt5(Pa ge-1)".
        I need to access the content of a "text box" (named control-A) on "Page-3"

        Within VBA ... How do I access access "Control-A" on "Page-3".
        If I have focus set to "Page-1" ?

        Thanks In Advance ...
        You may want to lok at this also:
        How to Access Tabs on a Tab Control

        Comment

        Working...