By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

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

P: 3
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(Page-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 ...
Mar 20 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 374
Expand|Select|Wrap|Line Numbers
  1.     me.[Control A].Value 'If there is a space between the word Control and A
  2. me.ControlA.Value 'If there is no spaces between the word Control and A
  3.  
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.
Mar 20 '08 #2

P: 3
perfect ... thanks
Task is now working as expected ...
Mar 21 '08 #3

ADezii
Expert 5K+
P: 8,597
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(Page-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
Mar 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.