Access - Form Control Button vb to change to a different Tab Page in same Form

Ok,
Trying method 3 above......

The Property Sheet shows:
Name = Page2 (no spaces)
Page Index  = 1

So in the coding of a on click event from Page1, Page Index 0 I put

Me.Page2.Value = 1

I get
Compile Error:
Method or data member not found.

????????????

Tried number 1 also....

Me.page2.SetFocus

Same error??????



JUST FYI
Don't think it matters but..... I have a Caption for each tab......
Page 2's caption is [LVL Control Totals]

No points here... Ron's got your answer.

"Page2" is the name of the page, not the tab control.  So if you are referring to Page2, you should use Method 1 in his post:

--->>> Me.NameOfPage.SetFocus

Me.Page2.SetFocus


Edit...

Interesting.  I could have sworn there was an hour since wlwebb's last post (otherwise I wouldn't have jumped in).

For number 3, you need to use the name of the Tab control, not the name of the page.
Is this Tab control on the same form as the the button with the OnClick event?

mbizup

we may have crossed posting.......

this is a cut and paste direct from how I keyed it.......

Me.Page2.SetFocus


This is a cut and paste direct from the property sheet item NAME
Page2


Still get the Compile error......  ????????????

For number 3, you need to use the name of the Tab control, not the name of the page.
Is this Tab control on the same form as the the button with the OnClick event?

All the "Tabs" are in the same "Form" that form is named "frm_DataReporting"
I have currently 5 tabs

I have given the tabs a Caption

The Caption of the one I'm on with the Control button is "LVL Data Reporting"
The Caption of the one I'm trying to make the visible/active one is "LVL Control Totals"

Guess I'm not understanding what I'm looking at........ or don't understand the terminology....


All I understand is what lines I'm seeing on the Property Sheet.....  

When you say the "Name of the Tab Control"  is that not the same as NAME on the Property Sheet???????

Here is a picture of a Tab control named tabSurvey which holds two pages named Page1 and Page2

Interesting.  I could have sworn there was an hour since wlwebb's last post (otherwise I wouldn't have jumped in).

@Miriam, I get that too.  Sometimes I add a post that looks like no one's answered for the past hour, and then I see my post is the 4th one down with the correct answer already provided.  So I quickly delete my post.  So strange!

The all say TabCtl0

Since you didn't rename it, that is the default name given by Access.
If you don't rename it, you would use Me.TabCtl0.Value=1 to go to the 2nd page (Index 1).

Personally I like to rename my tab controls and pages so that it's easier to follow in code.

Tried...... I can't get it to work....... too stupid..........

Here is a stripped out... the only thing in this is the 3 or 4 forms..... no data .....

Once it uploads I'll come back on and edit this to add the form name that starts it...

.....
Ok the main form is frm_DataReporting.

Once you open that form on the first tab, the only control button I've tried altering for this tabbed stuff is "Machine Pull"....
Tabbed-Form.accdb

OHHHHHH... Now I understand......!!!!!  Helps I guess if I understood all the terms....

Split the points between both your fixes since maybe next time I'll know the difference between the two.

Thanks Irog

At least now you know
:-)