Form Footer wont add sum of Text Field in Form Detail

[allenEd]

Hi,

I have been trying for days to sort this one out! any help would be welcome.

I have a subform with prices and qty, based on fields of a table.... The main form is linked to the sub form by customer ID (if that has any relavence)

I then have a text box in the subform multiplying the qty by price...The pric shows up fine. But if I try and SUM the text box in the form footer, I get #Name error..


any clues please,,

thanks
Allen

 

[hymn]

all I ever do create a text field in the footer then go into properties of that field and type =Sum[TextFieldName] and bingo it sums the field required

Hope this helps
Hymn

 

[hymn]

oops
posted before checking the =Sum[????] is typed into the Control Source in the properties of that field

Hope this helps
Hymn

 

[allenEd]

Thanks, but I have tried that, and get #Name.