#Name? fully qualified name

[Guest]

I have a form named [frm_DataEntry] with a subform called [frm_Inv] that is a
datasheet with a field [pmts].

I am trying to add a control to the form [frm_DataEntry] to sum the field
[pmts] in the subform but can't seem to get the fully qualified name just
right. I keep getting the #Name? in the control on the form.

=Forms!frm_Inv!txt_pmts

 

[Guest]

This is a common misunderstanding. You don't address the name of the
subform, you address the name of the subform control on your main form. The
structure is:
Me!subformname.form!controlname

 

[Guest]

Try:
Me.frm_Inv!Form.txt_pmts

This assumes that the subform control in frm_DatEntry is called frm_Inv.
This might be different from the name of the form it contains.

Barry

 

[ManningFan]

I think you have to reference the subform control. Check to see what
the name of your subform is, if it defaulted to frm_Inv then change the
name to sfrm_Inv so you can distinguish between the two.