subform total gives # error

[rudwan]

i tried many and many times to make the same of
Northwind.orders.subtotal but always gives # error
only at orders forms it gives accurate result to sum any
filed , but in other failed and always gives # error
what i can do ?

 

[John Vinson]

i tried many and many times to make the same of
Northwind.orders.subtotal but always gives # error
only at orders forms it gives accurate result to sum any
filed , but in other failed and always gives # error
what i can do ?

Please explain your question.

"always gives # error only at orders form it gives accurate result" -
I'm sorry, but that simply doesn't parse!

1. What did you do?
2. What result did you want?
3. What result did you get?

 

[rudwan]

i make textbox at subform footer like this :
text1=sum([value])
then at main form i make textbox to get total like this :
total=[subform].form![text1]

but it gives # error

same way at northwind db

-----Original Message-----

 

[John Vinson]

i make textbox at subform footer like this :
text1=sum([value])
then at main form i make textbox to get total like this :
total=[subform].form![text1]

but it gives # error

same way at northwind db

For "subform" you need to use the Name property *of the Subform
control* on the mainform, not the name of the Form within that control
- they are not necessarily the same!

If this isn't the problem please post the EXACT (copy and paste)
control source properties of text1 and total, and the SQL view of the
Recordsource of the subform.