467,926 Members | 1,829 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

Me. and the Tab Control

If I am in a form that has a Tab control, will Me. refer to only things on the current Tab or does it refer to anything in the current form.

What I'm trying to do is use one Tab to collect information, and then display it for review (prior to saving with an append query) on another Tab.

I'm not sure how to explain it further, so ask what ever questions you need for clarification.

Greg Johnson
Jan 31 '20 #1
  • viewed: 1189
3 Replies
Expert Mod 16PB
Hi Greg.

Welcome to Bytes.com.

Off the top of my head the Me.Controls() Collection refers to all the Controls within the Form as a whole. This doesn't include Controls on a Form within a SubForm Control but does include all Controls within Sections & Pages (Tabs). Me. can also reference all these directly of course.

Sections have their own separate .Controls() Collections, but Pages don't. That means they can be referenced via the Section as well (But not the Page.) but this doesn't preclude them from being referenced directly via Me. too.

All this is very logical. Excuse me for asking, but it seems quicker and easier to test this out for yourself than to post a question. Posting a question isn't a problem. It all adds to the repository of answers we provide - it just confused me why anyone would make the effort to write that all down instead of just testing quickly.
Feb 1 '20 #2

I thought of testing right after I hit send. I haven't used Access for years and I'm trying to get back into it.

Thanks for your reply.
Feb 1 '20 #3
Expert Mod 16PB
Always the way :-D

I hope you found the answer helpful anyway.
Feb 2 '20 #4

Post your reply

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

Similar topics

6 posts views Thread by martin | last post: by
2 posts views Thread by John Lau | last post: by
5 posts views Thread by serge calderara | last post: by
2 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.