How to sum values in text box with a formula?

[tom]

I am using the formula

=sum(NameOfTextBox)

This is coming back asking for the name.

NameOfTextBox has a formula in it.

 

[Jerry Whittle]

Where are you trying to do this: a form or report header or in the detail?

Sometimes Access gets confused if the text box and its control have the same
name. Try changing the name of the text box to

txtNameOfTextBox

and the sum to

=sum(txtNameOfTextBox)

 

[tom]

I am trying to sum the values in the detail(the detail has a formula) on a
form. All the names are different.

The textbox with the sum function is in the footer.