Subform within a Subform

[daved2424]

I have a form which is set to single form. Within that form is a subform which is set to continuous form.

What I want to be able to do is create another subform within that subform but keep both of the subforms set to continuous form but Access wont let me do that.

All I want to achieve is to be able to show all information relating to one single record in my master table cascaded down through two other tables, I hope that makes sense.

Any help anyone can provide would be invaluable.

 

[RuralGuy]

1st SubForm s/b a single form with 2 Continuous Form SubForms on it.

 

[daved2424]

I don't really understand what you mean.

I have a record, which may have many records associated with it in a second table, of which any of these may have many records associated to them in a third table. I want to able to display all of this information on the screen at once and not have to cycle through records to see the information.

 

[RuralGuy]

You can link the 1st SubFormControl to the MainForm and the 2nd SubFormControl to the 1st SubForm. You can put SubFormControls side by side on a form.

 

[daved2424]

I got that far, but I want a continuous subform within a continuous subform, which it will not allow me to do.

 

[boblarson]

I got that far, but I want a continuous subform within a continuous subform, which it will not allow me to do.

That's right. You can, put a subform into a continuous subform's FOOTER though. But that's as close as you're going to get.

 

[RuralGuy]

I would suggest something similar to what Albert Kallal has done at his link.