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!