Calculated text box on form

[wikus]

I created a textbox on a form which should show the sum of 3 other fields on the form. When I open the form I get a #NAME? error in the textbox.
Can someone please help?

 

[Trevor G]

What is your criteria?

 

[wikus]

I have 3 price fields and the calculated field is just the sum of the 3. I typed the formula in the textbox directly: =field1+field2+field3

 

[Trevor G]

Try this =SUM([Field1]+[Field2]+[Field3])