Re: Any Grandparents out there?
From: I_was_here (kstetka_at_yahoo.com)
Date: 07/30/04
- Next message: JohnLute: "Help Coding Delete Child/Parent Records"
- Previous message: Lynn Trapp: "Re: How to open a file using VBA"
- In reply to: John Smith: "Re: Any Grandparents out there?"
- Messages sorted by: [ date ] [ thread ]
Date: 30 Jul 2004 10:56:28 -0700
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" <johnDOTsmithATbromleyhospitalsDOTnhsDOTuk> wrote in message news:<e4pAx9hdEHA.3380@TK2MSFTNGP12.phx.gbl>...
> 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" <kstetka@yahoo.com> wrote in message
> news:58e54da4.0407291009.452a9396@posting.google.com...
> > 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?
- Next message: JohnLute: "Help Coding Delete Child/Parent Records"
- Previous message: Lynn Trapp: "Re: How to open a file using VBA"
- In reply to: John Smith: "Re: Any Grandparents out there?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
