Hi,

I have the following Forms:

[Form A] - Main form - Single form type
[Form B] - Continuous form
[Form C] - Continuous form
[Form D] - Continuous form
[Form E] - Continuous form

I want to add [Form B], [Form C], [Form D], [Form E] as sub-form on the mainform [Form A].

The Forms have the following relationship based on the underlying table:

[Form A] 1:M [Form B] 1:M [Form C] M:M [Form D] M:1 [Form E]

I would also like that the forms are linked with each other ie, if I select a record on one of the parent Form, the corresponding child records should come up in the sub-forms.

I have tried doing this by placing:
[Form E] in [Form D]
[Form D] in [Form C]
[Form C] in [Form B]
[Form B] in [Form A]

However, I face two problems with this approach:

1. The continous form change to single form. I get this error - "A form with a subform object cannot have its DefaultView set to Continuous forms. You tried to add a subform to a form in design view. MSAcess will reset the property to Single Form."

2. The final product (Form A with all the sub-form) is not very eye pleasing. All the sub-forms are nested within each other and looks very complicated.

I am attaching the screen shots.
- The second screen shot shows my final product.
- The first screen shot shows the way I would like to see the Form and the Subform.

Could you please advise re my problems?

put first your continuous form to a new form. each subform to each new form.
add these new form to the main form. and set child/ parent link