By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,695 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,695 IT Pros & Developers. It's quick & easy.

subform within a subform

P: n/a
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?

Dec 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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
dl*********@hotmail.com
http://amazecreations.com/datafast
"ryan" <ry***@usec.com> wrote ...
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?

Dec 19 '05 #2

P: n/a
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.

Dec 19 '05 #3

P: n/a
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.

Dec 19 '05 #4

P: n/a
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.

Dec 19 '05 #5

P: n/a
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.

Dec 19 '05 #6

P: n/a
Thanks. CanShrink to No and CanGrow to Yes --- This is how I found it
to be set up.

Dec 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.