Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tab Control inside a Tab Control

Status
Not open for further replies.

abenitez77

IS-IT--Management
Oct 18, 2007
147
US
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?
 
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.
 
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?
 
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:

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

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

Duane
Hook'D on Access
MS Access MVP
 
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

 
ok, tried that and now I get:

Run-time error '2465':
Microsoft Office Access can't find field 'Form' referred to in your expression
 
I tried this:
Forms!F_workspacePP!SubFrmPPTab5.Form.SubFrmTab05PP.Form.Recordsource

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

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top