[AccessD] Parent - subform control references

would this work for the control on subform1?

me.txtMyControl = Me.Parent.sbfrmMySubForm2.txtFieldNeeded


For the 2nd situation:

Me.txtMyTextfieldOnParent = nz(me.sbfrmSubForm1.txtField1,0) *
nz(me.sbfrmSubForm2.txtField,0)


On Mon, Sep 13, 2010 at 7:47 AM, Arthur Fuller <fuller.artful at gmail.com> wrote:
> Suppose I have a form containing two subforms, call them main_frm and fsub1
> and fsub2.
>
> A couple of situations are of concern:
>
> 1. A control on fsub1 needs to obtain the value of a control on fsub2.
> 2. A control on main_frm obtains its value by multiplying the value of an
> fsub1 control by a value on fsub2.
>
> I've forgotten how these references work. Can someone remind me? I also
> remember seeing a document that spelled all this out explicitly but I can't
> locate it now that I need it. Has anyone got a link to said document?
>
> TIA,
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>