never can get this right....going from one inbedded subform to another for a value

[sparks]

I am in a subform on a subform and need to get to a subform on a
subform...LOL
on 2 tabs.

so I have

FORM MAIN

sub1 sub3
subs2 subs4
val1 val2

so to get a value on subs2 for a calc value in subs4
is the correct way in subs4
me.parent.parent which is on form main

me.parent.parent.sub1.form.subs2.form.val1

I can't get this to work and I know its something to do with my
reference to form.
doesn't the form always go after the formname?

thanks big time for help

Jerry

[King Ron]

Is the form bound? if so, it might be easier to retrieve the value from
the underlying table rather than the UI...

However: as far as I can tell, the reference chain you quote above
should work: one thing to verify is that in your example 'sub1' and
'subs2' are the names of the .Subform controls on the parent form, not
the names of the .Form objects that are the .Subform controls data
sources...

King Ron of Chi

[RoyVidar]

sparks wrote in message <tf********************************@4ax.com> :

I am in a subform on a subform and need to get to a subform on a
subform...LOL
on 2 tabs.

so I have

FORM MAIN

sub1 sub3
subs2 subs4
val1 val2

so to get a value on subs2 for a calc value in subs4
is the correct way in subs4
me.parent.parent which is on form main

me.parent.parent.sub1.form.subs2.form.val1

I can't get this to work and I know its something to do with my
reference to form.
doesn't the form always go after the formname?

thanks big time for help

Jerry

Fortunately, I haven't had the need for such linking;-)

Keep in mind that what is used when referencing, is the
subform control name, which may differ from the form name
as viewed in the database window. It might be that, which
is causing this.

You might want to try the following:
One way of obtaining the correct reference, is by invoking
the expression builder from the controlsource of one of
the controls (val2?), then doubleclick through forms,
loaded forms, main form, sub1, subs2, val1, which
should provide you with the correct reference.

--
Roy-Vidar

[pietlinden]

did you read Keri Hardwick's article at www.mvps.org/access about
referencing controls on forms and subforms? If you follow that you
should be able to work it out...