I am developing a db for capital budget requests. I have several pop up forms that I use as requestor woksheets. Most are continuous forms that use the Sum() function in the footer. I have one form, though, that I cannot get to work. It displays #Name? in the totals boxes (I have one for each of three years). My control source statement is:
=Sum([CostPerUnit]*([Forms]![frmMainScreen]![InpatientProcsY2]+[Forms]![frmMainScreen]![OutpatientProcsY2]))
If I remove Sum from the statement I get the correct answer for Cost * Procedures.
I added a test field to my table, query and form to make sure the formulas in the controlsources weren't causing the problem. Its total also came up as #Name?. Does anyone have any ideas as to what's wrong?
=Sum([CostPerUnit]*([Forms]![frmMainScreen]![InpatientProcsY2]+[Forms]![frmMainScreen]![OutpatientProcsY2]))
If I remove Sum from the statement I get the correct answer for Cost * Procedures.
I added a test field to my table, query and form to make sure the formulas in the controlsources weren't causing the problem. Its total also came up as #Name?. Does anyone have any ideas as to what's wrong?
