Tab Control inside a Tab Control

[abenitez77]

I want to put a tab control inside another Tab Control. I have 10 tabs on the parent tab control. When I try placing a tab control in the 6th tab of the parent tab control, it works but when I move to another tab on the parent tab, the child tab control shows up on every tab of the parent tab control. How do I get it to only show up on 1 of the parent tab that I place it on?

 

[MajP]

When you paste it you have to be sure to select the page not the control. You "floated" it over top of the other control instead of embedding it in a page.

 

[abenitez77]

I created a form and put the tab control in that form and then put that as a subform in the tab control that is inside the main tab control. Now I have another issue related to this.

I have my main form called: F_workspacePP
Then I have a Tab control called: TabMain
I then created a subform called: SubFrmPPTab5 (I put this subform in Tab5 of the TabMain)
Inside the subform called (SubFrmPPTab5), I have a Tab Control called: SubTab
On the first tab called Tab1 of SubTab, I have a subform called: SubFrmTab05PP

I don't want SubFrmTab05PP to open with the record source filled in until I click on Tab1. So I am filling in the recordsource when they click the tab and when they close the main form, I am clearing the recordsource. What is the syntax for getting to the recordsource?

I have something like this for another tab without the tab control within a tab control:
Forms!F_workspacePP.[SubFrmTab02PBD].Form.RecordSource = ""

I tried chaning it to work on the one that has a tab control within a tab control to this:
Forms!F_workspacePP.[SubFrmPPTab5].Form.SubFrmTab5PP.RecordSource = ""

Is this correct?

 

[dhookom]

You can test this type of expression by opening the debug window (press Ctrl+G) and then enter the expression to see if it works:

? Forms!F_workspacePP.[SubFrmPPTab5].Form.SubFrmTab5PP.RecordSource

If it doesn't work, then try something else.

Duane
Hook'D on Access
MS Access MVP

 

[abenitez77]

I changed it to this:
Forms!F_workspacePP.[SubFrmPPTab5].SubFrmTab05PP.Form.RecordSource = ""

and I get the error msg below:

Run-Time Error '438':

Object doesn't support this property or method

 

[dhookom]

You can typically ignore tab control names. Try something like

? Forms!F_workspacePP!SubFrmPPTab5!Form!SubFrmTab05PP.Form.Recordsource

Duane
Hook'D on Access
MS Access MVP

 

[abenitez77]

ok, tried that and now I get:

Run-time error '2465':
Microsoft Office Access can't find field 'Form' referred to in your expression

 

[abenitez77]

I tried this:
Forms!F_workspacePP!SubFrmPPTab5.Form.SubFrmTab05PP.Form.Recordsource

and this seems to be working...need to test it more.

Thanks!

 

[PHV]

Theb M$ recommended syntax is:
Forms!F_workspacePP!SubFrmPPTab5.Form!SubFrmTab05PP.Form.Recordsource

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[abenitez77]

Thanks! I made the change accordingly.