Subforms within tabs

[captain1974]

Access 2003
Can anyone tell me if it is possible to put a subform of the current form (in the first tab) into the next tab, and the subform of that subform into the next tab and so on. I am thinking this isn't possible, but trying to find a way to tidy up forms which contain multiple subforms (within each other).

 

[The_Doc_Man]

1. Access imposes a nesting limit.
2. Tabs are not nesting structures if they are tabs of the same parent.
3. A sub-form implies a very specific structure that must be inside the form that is its parent. From your description, the child form would not be within its parent but on another tab page.

Therefore, if I have read your question correctly, the answer is "NO" you cannot get there from here.

There is no reason why you can't put several tabs up on a parent form and have different child forms, one on each tab. But in that kind of structure the child forms are children of a single parent form and are at "level 2" (if the parent is "level 1") in depth hierarchy. Which doesn't quite seem to match your description.

 

[Moniker]

The MultiPage control is a "true" tab control that works the way you thought the Tab Control would work. Add that reference to your toolbox (click on the "more controls" button in the toolbox in design view).

 

[captain1974]

Thanks for both of your replies.
Moniker - Can you point in a direction where I might find out more about the Multipage control and how to use?

 

[Moniker]

To see an example of a multi-page form that uses the tab control, open the Employees form in the sample database Northwind.mdb (included with Access).

 

[galanthus]

Hi

I've been tying to do the same thing putting subforms onto separate tabs which of course isn't working!! I now understand that I should use multipage instead.

My question is can I put my existing form and its two sub forms onto three pages. I've tried 'drag and drop' and 'cut and paste' but I get the same form appearing on every page.

Thanks