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?
Many thanks.
PS: I don't have Photoeditor therefore could not attach it as picture.