Nested forms

[jenatawp]

I have a form to which I am trying to add a subform with a subform.

If I look at the table in the datasheet view, it works properly. Each level
(I have a Maintenance Report, Maintenance Info, and Maintenance Detail)
allows me to look at the next level below it (with the little + sign on the
left side).

However, when looking at the form in form view, the Maintenance Report(which
is set to single form) works fine with the Maintenance Info (set to
datasheet). However, I cannot view the Maintenance Detail (it is also set to
datasheet) in form view, because there is no + sign at the Maintenance Info
level.

I know that there has to be some simple little setting that I need to fix,
but I just can figure it out. Does anyone have any suggestions? I have
checked the relationships and child/master fields, but I just can't come up
with what I am doing wrong.

I will appreciate any suggestions! Thank you in advance for your assistance.

 

[Amy Blankenship]

I have a form to which I am trying to add a subform with a subform.

If I look at the table in the datasheet view, it works properly. Each
level
(I have a Maintenance Report, Maintenance Info, and Maintenance Detail)
allows me to look at the next level below it (with the little + sign on
the
left side).

However, when looking at the form in form view, the Maintenance
Report(which
is set to single form) works fine with the Maintenance Info (set to
datasheet). However, I cannot view the Maintenance Detail (it is also set
to
datasheet) in form view, because there is no + sign at the Maintenance
Info
level.

I know that there has to be some simple little setting that I need to fix,
but I just can figure it out. Does anyone have any suggestions? I have
checked the relationships and child/master fields, but I just can't come
up
with what I am doing wrong.

I am amazed it would let you set a form that includes a subform to
DataSheet. Try setting it to Single Form and see what you get.

HTH;

Amy

 

[jenatawp]

Amy:
Thanks for the response. If I set it to single form, it does work, but then
it will only let me review one maintenance record at a time, which is not
what I was hoping to do.

I have another database that I built that has datasheets as subforms, but I
can't figure out what I am doing differently on this one!

Let me know if you'd like me to send you a copy of either one so you can see
more clearly what I am having difficulty doing.

Thanks again for your help!

Jen

 

[Ron2006]

It can work. I just created a form
that has a datasheet subform
that has a datasheet subform
that has a datasheet subform

AND IT WORKED

The only thing I can think of is maybe check the parent(master)/child
relationiships on the forms for each of them to see if they are set up
properly.

Ron

 

[Amy Blankenship]

Amy:
Thanks for the response. If I set it to single form, it does work, but
then
it will only let me review one maintenance record at a time, which is not
what I was hoping to do.

I have another database that I built that has datasheets as subforms, but
I
can't figure out what I am doing differently on this one!

Yes, you can have a datasheet as a subform, but to my knowledge you are not
supposed to be able to have a datasheet be a parent form of another form.

HTH;

Amy