subform total gives # error

  • Thread starter Thread starter rudwan
  • Start date Start date
R

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 ?
 
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 ?
Click to expand...

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?
 
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-----
Click to expand...
 
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
Click to expand...

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.
 
Back
Top