Nested forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenatawp - 12 Mar 2008 15:56 GMT

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.

Signature

J. Shafer
AWP Industries, Inc.

Reply to this Message

Amy Blankenship - 12 Mar 2008 20:34 GMT

>I have a form to which I am trying to add a subform with a subform.
>
[quoted text clipped - 19 lines]
> 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

Reply to this Message

jenatawp - 12 Mar 2008 20:46 GMT

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

Signature

J. Shafer
AWP Industries, Inc.

> >I have a form to which I am trying to add a subform with a subform.
> >
[quoted text clipped - 26 lines]
>
> Amy

Reply to this Message

Ron2006 - 12 Mar 2008 22:14 GMT

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

Reply to this Message

Amy Blankenship - 12 Mar 2008 22:34 GMT

> Amy:
> Thanks for the response. If I set it to single form, it does work, but
[quoted text clipped - 5 lines]
> 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

Reply to this Message