473,418 Members | 2,008 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,418 software developers and data experts.

subform within a subform

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
6 3155
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
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
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
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
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
Thanks. CanShrink to No and CanGrow to Yes --- This is how I found it
to be set up.

Dec 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: ivan | last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within that subform is another subform (OrderDetail). That subform (OrderDetail) is displayed in Datasheet view. When I am...
5
by: Ellen Manning | last post by:
Using A2K. I need the syntax to set the recordsource for a subform within a subform. The "main" subform's recordsource changes based on user input. I need to change the recordsource on the...
2
by: Maggieanp22 | last post by:
I'm designing a db which stores client details but each client has multiple 'occasions'. For each occasion there is a section which has items purchased (there are sometimes none, sometimes...
7
by: kevin.jonas | last post by:
Let say I have a form called "frmMachineSpecs" witht wo subforms, "frmSpecs" and "frmMachines". Both subforms are in datasheet view. The first control in "frmSpecs" is "txtOEM_No". I want to...
2
by: Tom Lee | last post by:
Dear All, I am trying to put together a small homemade accounting database and have encountered the following problems, hope you guys can help: 1) I have a subform which includes 3 columns-...
1
by: Parasyke | last post by:
I have a subform within a tabpage that will requery/refresh (?) if I press F9 and it will update the data in the subform, but I have tried various combinations of Me!SubformName.requery...
6
by: DMUM via AccessMonster.com | last post by:
Hello I am trying to pass the name of my subform to a function/sub but I can't seem to get it to work. I am using an autokey function (ctrl E) to unlock text boxes on a subform. I have a few...
8
AccessIdiot
by: AccessIdiot | last post by:
I'm having some trouble going from one form to another and carrying over the ID field (see this thread if you are interested). So I was thinking about ways around the problem. As far as my very...
5
by: bplantes | last post by:
I have a "Dashboard" in a tool I am building which has a list of different buttons. Clicking on each button will display different subforms which show up in a window to the right of the menu. One...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.