Re: Any Grandparents out there?

From: John Smith (johnDOTsmithATbromleyhospitalsDOTnhsDOTuk)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 11:24:46 +0100

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?

Relevant Pages

  • Re: OT: The View
    ... I would NEVER suggest anyone continue having their kids associate with a child molester, even if said molester happens to be the grandparent, parent, etc. ... A parent who was not physically abusive, but who has been emotionally and verbally abusive all one's life? ...
    (rec.arts.tv.soaps.cbs)
  • Re: Being the mother of yourself?
    ... one is one's own parent, half the genetic information apparently comes ... isn't a grandparent typically only as genetically similar to you ... A first cousin in a regular family tree also has one-quarter of their ... DNA from that grandparent. ...
    (rec.arts.sf.written)
  • Re: OT: The View
    ... I would NEVER suggest anyone continue having their kids associate with a child molester, even if said molester happens to be the grandparent, parent, etc. ... A parent who was not physically abusive, but who has been emotionally and verbally abusive all one's life? ...
    (rec.arts.tv.soaps.cbs)
  • Re: Gakked from Donna: Stitching question and conversation starter
    ... exposed young from someone (scouts, parent, grandparent, etc.), then ...
    (rec.crafts.textiles.needlework)
  • Any Grandparents out there?
    ... fields: GP PP1 CC1 ... I basically want to have CC1+CC2+CC3+CC4 show up on the Grandparent ... textbox in the Child form and then in the Parent form using something ...
    (microsoft.public.access.formscoding)