disappearing subform (sorry for cross-posting)

[jjmclell]

Hi, sorry I've cross-posted this...I didn't realize there was a forum
strictly for forms and I posted this in the formscoding forum but
anyways...

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 and was
designed through properties boxes and wizards so there's no code
behind any of this except for some record navigation buttons. 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

 

[John W. Vinson]

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.

VERY VERY odd. I've seen subforms go blank but never seen one vanish
altogether!

Check the subform control's Can Grow and Can Shrink properties; if either is
Yes try setting them to No. Does this affect the behavior?

John W. Vinson [MVP]

 

[jjmclell]

VERY VERY odd. I've seen subforms go blank but never seen one vanish
altogether!

Check the subform control's Can Grow and Can Shrink properties; if either is
Yes try setting them to No. Does this affect the behavior?

John W. Vinson [MVP]

Hi John,

Thanks for your reply. I eventually just gave up and rebuilt the form
from scratch and now it works perfectly. I have no idea what the
problem was...the only thing I can think of that I changed when I
rebuilt the form was originally, for SUBFORM2, I used a pre-existing
subform (SUBFORM3 nested in SUBFORM2). Instead of creating those
subforms from scratch when I was designing my flawed form, I thought
I'd save time and just salvage SUBFORM2. I don't actually know why
this would be a problem but when I rebuilt the form, I designed
SUBFORMS 2 & 3 from scratch and the form works without a hitch now.
Anyways, like I said, thanks for your response.

jjmclell