subform within a subform

[ryan]

I created in design view a subform within a subform. However the
subform within the subform in only visible in design view. In form
view the subform within the subform is not visible. I have only nested
from the mainform to a subform into another subform. Any clues why my
subform within my subform is not visible in form view?

[Danny J. Lesandrini]

Re: subform within a subform

If the subform is linked (Master/Child field linking properties) and there
are no records and the AllowAdditions property of the subform is False,
then it's possible that no controls would display.
--

Danny J. Lesandrini
dlesandrini@hot mail.com

http://amazecreations.com/datafast

"ryan" <ryanr@usec.com > wrote ...[color=blue]
>I created in design view a subform within a subform. However the
> subform within the subform in only visible in design view. In form
> view the subform within the subform is not visible. I have only nested
> from the mainform to a subform into another subform. Any clues why my
> subform within my subform is not visible in form view?
>
>[/color]

[ryan]

Re: subform within a subform

The AllowAdditions property of the subform is "yes". The subform has 1
record in it for testing.

Hope you can think of another reason why it isn't visible.

[Steve]

Re: subform within a subform

Check the CanShrink and CanGrow properties. Set the CanShrink to No and
CanGrow to Yes. Danny's suggestion is the most common case, in my
experience, when a subform or subreport refuses to display.

Does the subform display OK when you preview it all by itself? As
unclear as that is, I mean when you double-click the subform's name in
the Database window, do any records display? If not, there is probably
something wrong with the setup of your subform. If this is the case,
you need to fix the subform before it can even try to work from its
parent form.

I would, for troubleshooting only, bind the subform directly to a table
and see if it displays the records in that table. If not, you'll know
that there is a problem with the way your subform works. If you have
VBA code behind the subform, try compiling it to see if there are
errors that need to be fixed before running the subform in its parent
form.

[ryan]

Re: subform within a subform

I have Access 2003. I don't find any property labeled CanShrink or
CanGrow.

The subform works well independently from the main form. When I double
click on the subform it shows what is in the table its's tied to. I
don't have any VBA code that I know of. I sure didn't do any VBA.

Please keep suggestions coming. This database is brand new with very
little data. I'm just trying to get the first data entry form going.

Thanks for your help.

[Steve]

Re: subform within a subform

CanShrink and CanGrow are properties of the subform object, not
properties of the form composing the subform (confusing, yes). To gain
access to those properties, you need to open the parent form and select
the subform object.

[ryan]

Re: subform within a subform

Thanks. CanShrink to No and CanGrow to Yes --- This is how I found it
to be set up.