Forms and subforms

[ByB]

Hello,

I am developping an app in VBA/Access, and I would like to create a
form with several subforms. But my problem is that the number of
subforms is not a constant, and can be different each time the form is
opened, since the data to display in the subforms comes from a
database.

Is there a solution to create such a form, with a variable number of
subforms, or do I need to have a fixed number of subforms in my form ?

Thank you for any idea or hint.

 

[Tony Toews [MVP]]

I am developping an app in VBA/Access, and I would like to create a
form with several subforms. But my problem is that the number of
subforms is not a constant, and can be different each time the form is
opened, since the data to display in the subforms comes from a
database.

Is there a solution to create such a form, with a variable number of
subforms, or do I need to have a fixed number of subforms in my form ?

I'd use a tab control and then either make the various tab pages
visible or not depending on if the subform was applicable or not.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/