summing on a textbox

[sturner333]

On a form I calculate the sum of 2 numbers from a table and place them in a corresponding textBox for that record on the form. The user can update these 2 numbers or add a new record.I would like to sum the textBox's with the products from each record in a textBox in the form footer but I understand you can't do this.? How would I accomplish this task?
Thanks!

 

[Remou]

There is a problem summing calculated fields in a report, but I do not think that this applies to forms. You should be able to create a textbox in the form footer and set the control source to, say,
=Sum([txtAdd])

 

[sturner333]

I get a #Error in the textBox when I put =Sum([textBox]).

 

[Remou]

Have you tried using the Expression Builder?