Nested Continuous Subforms in Microsoft Access

Nested Continuous Subforms
By Richard Rost

2 years ago

Many To Many Continuous Upload Images Link
Elaine Heltman
2 years ago

Thanks, Rick. You clearly demonstrate subform creation using one-to-many relationships and how you can relate and show all the detail from each each table using continuous forms. I'd like to do the exact same thing with many-to-many relationships: use continuous forms and show all the detail, not only the "product" and "vendor" names (so to speak). Would that require using dlookup from an ID field in the the junction table subform to autopopulate a subsubform with the detail?
And, in the video, why place the subforms in the footer instead of in the body of the form? Thank you!

Richard Rost
2 years ago

You could join together any related info you want to display in a query, but keep in mind that info would only be for display only. You won't be able to edit it (usually).

You can ONLY put a subform in the form header or footer sections. Access won't let you put it in the detail section. Think about it, you'd have a copy of the subform for EACH detail record. It wouldn't look right.

Elaine Heltman
2 years ago

Thanks, Richard!

Richard Rost
2 years ago

My pleasure.

Ibrahim Hasouna
8 months ago

I know it will be a strange one, but, Can the the footer be on the right not in the bottom ? I know you laughing, but what I am trying to accomplish is to nest the subform horizontally instead of vertically, you know; like tree folder system

Richard Rost
8 months ago

Nope. Sorry. :(

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Nested Continuous Subforms