How many sub-forms can a main form have

[patsaison]

All the examples in books on forms and subforms show one main form with a subform. I want to split the one subform into two subforms, and am wondering if a main form can have multiple subforms. No where could I find a reference as to how many subforms a main form can have.

Does anyone have the answer?

What I want to do is use one main form as a tab page, followed by 2 or more tab pages with the subform information.

 

[Galaxiom]

Forms will allow for more than a reasonable number of subforms. You can also have subforms inside subforms. If you hit the limit you have data structure problems.

If you have a lot of subforms the tab control is good way to deal with displaying them.

I think the only limit is the number of objects in the whole database. This supposed to be somewhere about 750.

 

[patsaison]

Thanks for the quick reply