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

Me. and the Tab Control

P: 2
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
3 Weeks Ago #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,660
Hi Greg.

Welcome to

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.
3 Weeks Ago #2

P: 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.
3 Weeks Ago #3

Expert Mod 15k+
P: 31,660
Always the way :-D

I hope you found the answer helpful anyway.
3 Weeks Ago #4

Post your reply

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