Help with calculated controls

[DannyV]

Hello! I've been trying to get this to work for a while now. I'm trying to add calculated controls to my main form and subform but it seems to not want to give me the actual numbers I'm wanting it just gives me "#ERROR". This is what I did: On my subform in design view I added two text boxes with the text box tool. So, on one of them I gave it the name (in the property sheet) txtInvoiceAmtSum then I went to the Control Source and typed in =Sum(InvoiceAmt). For the other text box I gave it a name of txtInvoiceNumCount and set the Control Source property value to =Count(InvoiceNum), then I exited the "Subform in new window" window and went back to design view on my main form. I added two text boxes on my main form as well. On the first one I named it "Number of Invoices:" then I went to the expression builder and typed in this code "=[frmInvoiceSubform].Form![txtInvoiceNumCount]". On the other one I created on the main form I called it "Invoice Amount Total:" and went into the expression builder and typed in "=[frmInvoiceSubform].Form![txtInvoiceAmtSum]. After I did that I went back to layout view and it seems the code didn't work because it's showing me "#ERROR" on each of the boxes. Can anyone help me out with this? I'd really appreciate it. Thanks!

[maximus]

This is What I want you to check the =[frmInvoiceSubform].Form![txtInvoiceNumCount]

The Name marked in red has to be the name of the subForm control on the main form and not the name of the form that you may be using as a subform. To Check this out select the subform on the mainform. go to Subform/SubReport Properties and Check out the name of your SubForm Control.


if this solves your problem mark this thread solved.

refer attached screen shot

[DannyV]

This is What I want you to check the =[frmInvoiceSubform].Form![txtInvoiceNumCount]

The Name marked in red has to be the name of the subForm control on the main form and not the name of the form that you may be using as a subform. To Check this out select the subform on the mainform. go to Subform/SubReport Properties and Check out the name of your SubForm Control.


if this solves your problem mark this thread solved.

refer attached screen shot

OK, I checked and both the name and the source object are labeled as frmInvoiceSubform. So I believe that's what it should be at right? But it's still not working for me.