May 27 2012, 10:10 AM
Is the the limit on multiple dependent continuous subforms 2? I have a customer who wants me to develop a database where there are four levels of dependency. I have written a little test database but Access 2010 doesn't accept links beyond the second subform i.e. making the third subform dependent on the second subform. Does anyone have any work arounds?
May 27 2012, 10:27 AM
Can you upload the Db so we can see the structure
We may then be able to help
May 27 2012, 10:30 AM
I'm lost from the outset.
As far as I know you cannot place a subform into a continuous form at all, never mind have multiple levels.
May 27 2012, 10:49 AM
I don't recall there being a limit (I know I've been 7 layers deep before). The only caviat is you cannot place a subform in the Detail section of a Coninuous form. You have to use the Header or Footer section.
I've done a few projects like this before, and I've found it just as easy to set the record source of subforms using VBA rather than rely on the Master/Child links. It has always been faster.
May 27 2012, 11:01 AM
It went up from 3 to 7 levels, in 2002, and was still at 7 in v2007. As Walter said, in Continuous View Forms they can only be placed in the Header or Footer Sections.
May 27 2012, 11:17 AM
Well, I've learnt that that a bit too late in this life but maybe the next..../(:-)
May 27 2012, 02:23 PM
the linking of forms to subforms is easy to do in code, though, irrespective of a "ceiling" numbers of levels.
with a bit of code you can go any number deep, in whch case it is just a bit of interface design.
7 sounds a lot though. i cannot offhand conceive of a seven-deep relationship
so although you cannot place a continuous subform witrhin a continuous form, you can place both forms inside a container form, and link them together with no problem at all/
customers/orders/orderlines all continuous within a single form
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here