How to setfocus on a tab from subform on another tab

[saudkazia]

I have a mainform called [order list] which I have added two tab pages
Main form =Order List
Tab Control =TabControl1
Page 1 = ViewOrderTab / Order Summary Subform
page 2= OrderTab / Order Details Subform



I basically want to be able to double click on Order ID in subform on page 1 and open Page 2 and filter to the order ID selected. I figured if I could get it to open the page I can then filter it.

But despite best efforts it's not allowing me to setfocus to the page.

I have tried following with errors

me.TabControl1=1 [method or data member not found]
me.parent.TabControl1=1 [method 'parent' of object '_form_Order Summary Subform
me.Tabcontrol1.value=1 [same as 1]
me.parent.Tabcontrol.value=1 [same as 2]
me.TabControl1.ordertab.setfocus [same as 1]
me.ordertab.setfocus [same as 1]
forms![order list] variants of the above [Method 'item' of object 'forms' failed]
also tried with pages index but so far nothing works

It's strange that everywhere these commands are being referenced but I get errors. Can somebody point me in the right direction to get this to work

[June7]

What is the main form bound to?

You want the two subforms to be linked and synchronize the records? Review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

Once that works, deal with setting focus issue.

[JamesDeckert]

seems like this one should have worked
me.ordertab.setfocus
if you copied and pasted to your post, it's interesting that there is no capitalization.
You have listed OrderTab at the top, but ordertab below.
If this is correct, then you probably are not spelling something consistent.
the other choice is
forms("main form").ordertab.setfocus

[saudkazia]

Forms("order list").OrderTab.SetFocus - method of 'item' object 'forms' failed

[saudkazia]

June

I know how to link subforms. I can easily open a new form dialogue to open the correct form in another window but I want to emulate that with tabbed pages if possible

[JamesDeckert]

I'm doing it both ways I suggested earlier.
It makes me think there's a spelling difference between your code and the controls.
Maybe just make a blank form with some tabs with a button that changes focus to a different tab and see if that works.

[saudkazia]

I'm doing it both ways I suggested earlier.
It makes me think there's a spelling difference between your code and the controls.
Maybe just make a blank form with some tabs with a button that changes focus to a different tab and see if that works.

Are you trying with navigation subform as well. Maybe that is the difference. I will try it with blank form.

[saudkazia]

works on new blank form
Forms("form1").Page2.SetFocus

[JamesDeckert]

I was just testing by putting a button onto a form I already have which has tabs, each with a subform.
I don't know what you mean by navigation subforms and how would that affect the setfocus?

[saudkazia]

doesn't work on form1 as navigation subform. whats wrong

[ItsMe]

...by navigation subforms...

Perhaps they are using the Navigation Control.

[saudkazia]

navigation subform is when you have a list of buttons that when clicked will display a subform that is bound to each button. sort of like tabs but can only hold subforms and not other controls

[saudkazia]

Yes. Navigation Control. Which is referred to as Navigation Subform in the properties

[June7]

I don't like and don't use Navigation Control/Form. What you want might not be possible with it.

[saudkazia]

the reason Im using Navigation control is because I want to ensure that all the forms have a uniform theme and window and no windows are overlapping