disappearing subform

[jjmclell]

Hi there, I have a form that looks like this:


MAIN FORM

SUBFORM1

SUBFORM2

SUBFORM3


SUBFORM1 is nested in MAIN FORM; SUBFORM2 is nested in SUBFORM1; and
SUBFORM3 is nested in SUBFORM2. My problem is that SUBFORM1 keeps
disappearing on me when I'm in form view, circulating through
records. It happens whenever I go to the NEXT RECORD in MAIN FORM,
then go to the NEXT RECORD in SUBFORM2, and then go to the PREVIOUS
RECORD in MAIN FORM.....SUBFORM1 just disappears and SUBFORMS2 AND 3
move up to fill the space. Everything is in single-form view. One
strange thing is that I've got text boxes that show the values for the
parent/child fields to ensure everything's linked up properly and even
when SUBFORM1 disappears, the text box in SUBFORM2 still shows the
proper value in the child field that it would get from SUBFORM1 had it
not disappeared. Any ideas?

jjmclell

 

[Guest]

I have been told that Access can't deal with more than 2 nested subforms. I
think you ought to reconsider your form design.

 

[Dirk Goldgar]

In

I have been told that Access can't deal with more than 2 nested
subforms.

This is incorrect, at least as regards versions other than Access 2007
(about which I can't say). Earlier versions of Access had a limit of
something like 4 nested subforms (IIRC). This limit was increased at
some point; in Access 2002 you can have up to 7 levels of nested
subforms.

 

[Dirk Goldgar]

In

Hi there, I have a form that looks like this:


MAIN FORM

SUBFORM1

SUBFORM2

SUBFORM3


SUBFORM1 is nested in MAIN FORM; SUBFORM2 is nested in SUBFORM1; and
SUBFORM3 is nested in SUBFORM2. My problem is that SUBFORM1 keeps
disappearing on me when I'm in form view, circulating through
records. It happens whenever I go to the NEXT RECORD in MAIN FORM,
then go to the NEXT RECORD in SUBFORM2, and then go to the PREVIOUS
RECORD in MAIN FORM.....SUBFORM1 just disappears and SUBFORMS2 AND 3
move up to fill the space. Everything is in single-form view. One
strange thing is that I've got text boxes that show the values for the
parent/child fields to ensure everything's linked up properly and even
when SUBFORM1 disappears, the text box in SUBFORM2 still shows the
proper value in the child field that it would get from SUBFORM1 had it
not disappeared. Any ideas?

That's odd. In the absence of code that might be hiding the detail
section for SUBFORM1, I think it must have to do with the Link
Master/Child Fields of SUBFORM1. But I can't see why SUBFORM2 is
showing the value that ought to have come from SUBFORM1.

What are the Link Master/Child Fields of each subform, and what are
their recordsources? Are any of the recordsources, including that of
MAIN FORM, dependent on values on the form or subforms?

 

[John W. Vinson]

I have been told that Access can't deal with more than 2 nested subforms. I
think you ought to reconsider your form design.

--

That used to be true, Scubadiver, but with 2002 and beyond you can nest
subforms seven deep.

John W. Vinson [MVP]

 

[Guest]

I wouldn't want to have that many anyway. Maximum of two subforms for me.

 

[John W. Vinson]

I wouldn't want to have that many anyway. Maximum of two subforms for me.

Three for me, but I agree in principle!

John W. Vinson [MVP]