subforms

[Guest]

I have a number of forms that contain subforms which in turn contain other
subforms. Some of the latter are small utility subforms that function sort
of like controls. These are used in several of the first level subforms. If
I open, for example, 4 of the top level forms one at a time in any order,
everything is ok. If I open any one of the top level forms (these are not
modal forms) and then open any second form, everything is still ok. The
problem comes when I try to open a third. At that point, an error occurs
saying that the second level subforms are undefined in the third form. It
doesn't matter in what order I open the forms so it would appear that the
problem is something in Access. It won't allow more than 2 instances of the
second level subforms when in multiple forms. Any ideas?

 

[Guest]

Forget what I asked. I have since determined that my problem results from
the total number of controls/subforms that are supported at any one time. By
removing some groups of controls, I was able to get past the problem I was
seeing. I now need to know about limits on the number of controls and the
number of subforms that can exist at any one time? I haven't been able to
find anything in the help about it. The limitation is on the total number,
not on the number on any single form or subform since in my case, any two of
the forms could be open at one time but not a third. If anyone knows, what
are the limits on controls and on subforms if they have a separate limitation
over and above the number of subform controls?