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?

Hi

Can you upload the Db so we can see the structure
We may then be able to help

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.

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.

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.

Linq ;0)>

Well, I've learnt that that a bit too late in this life but maybe the next..../(:-)

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/

eg


customers/orders/orderlines all continuous within a single form