Any Grandparents out there?

  • Thread starter Thread starter I_was_here
  • Start date Start date
I

I_was_here

3 forms with 2 subforms as follows:

Grandparent
field: GP

Parent
fields: GP PP1
GP PP2

Child
fields: GP PP1 CC1
GP PP1 CC2

GP PP2 CC3
GP PP2 CC4

I basically want to have CC1+CC2+CC3+CC4 show up on the Grandparent
form in an unbound control.

I was able to get the sum up to PP1 and PP2 by using an unbound footer
textbox in the Child form and then in the Parent form using something
like:
=[Child].Form!RunningTotal in the parent form.

But I can't just create an unbound
footer textbox in child to bring it up to Grandparent? It doesn't
seem to want to read it....

=[parent].Form!RunningTotal in the Grandparent form where Runningtotal
is now in the footer of the Parent form...?
Any suggestions from any children, grandparents, or parents?
 
You can get there, you just have to work your way down the chain! The source
of your control on Grandparent needs to be :-

=ParentFormControlName.Form!ChildFormControlName.Form!RunningTotal

Substitute the names of your own SubForm controls (which may or may not be the
same as the names of the forms that they contain).
 
Thanks for the reply.
Actually what you suggested brings: CC1+CC2->PP1->GP, or
CC3+CC4->PP2->GP but never CC1+CC2+CC3+CC4 as it only adds once and
transfers twice.

Anyway, I'm an idiot. I realized that I could eliminate the parent
altogether and get the total that directly from the child table to the
grandparent table.

That was way too simple. Thanks!

John Smith said:
You can get there, you just have to work your way down the chain! The source
of your control on Grandparent needs to be :-

=ParentFormControlName.Form!ChildFormControlName.Form!RunningTotal

Substitute the names of your own SubForm controls (which may or may not be the
same as the names of the forms that they contain).

--
HTH
John

I_was_here said:
3 forms with 2 subforms as follows:
Grandparent
field: GP
Parent
fields: GP PP1
GP PP2
Child
fields: GP PP1 CC1
GP PP1 CC2
GP PP2 CC3
GP PP2 CC4
I basically want to have CC1+CC2+CC3+CC4 show up on the Grandparent
form in an unbound control.
I was able to get the sum up to PP1 and PP2 by using an unbound footer
textbox in the Child form and then in the Parent form using something
like:
=[Child].Form!RunningTotal in the parent form.
But I can't just create an unbound
footer textbox in child to bring it up to Grandparent? It doesn't
seem to want to read it....
=[parent].Form!RunningTotal in the Grandparent form where Runningtotal
is now in the footer of the Parent form...?
Any suggestions from any children, grandparents, or parents?
Click to expand...
Click to expand...
 
Back
Top