dsum wont work on subform

[John thomas]

Hi everyone
Every time i try to get info from a sub form or its table ,Things never sem to work.Is there something special you have to do for eg maybe going via the main form?
I am trying to use dsum as an alternative to multiplying info in the sub form
This is the code =DSum("SoldAtPrice*Quantity","[Order Details]","IDNewOrders=" & [OrderID FK])

It comes up with error

 

[bob fitz]

Where are you using your expression.
Can you tell us more about what you are trying to total.

 

[John thomas]

Hi bob
Thanks for your help
I have now solved the prolem it was due to me putting the wrong name in
However I always have trouble when dealing with sub forms .Is there a reason for this or is it just me (which is vary possible)

 

[smig]

if you try to read a SubForm data from a sub or function use the full path (Form.SubForm)

 

[John thomas]

Many thanks That explains a lot