This is what I'm working with:
- Text field "OrderTotal"
- Subform "SubOrders"
- - Field TotalAmount (= Sum(Qty * UnitPrice))
I want Orders!OrderTotal to have the same value as Orders!SubOrders.Form!TotalAmount, but when I set OrderTotal's source to
it doesn't give a value, but only #Error
And when I do it "manually" with this code:
I get the following error:
"Error -2147352567 (80020009) during execution: Method '_Evaluate' of object '_SubForm' failed"
Could you please help me with this? Thanks.