Calculation in Parent Form on data in Sub Form (1 Viewer)

[tinyevil777]

Hello all,

I have created a purchase order system, with a Parent Form containing data from 'PHeads_tbl' and a subform containing data from 'PLines_tbl'.

Financial information is held in PLines_tbl, and it has now been requested to have the Sum of all records in the Sub Form to be displayed on the Parent Form.

I have a control with the following code in:

=Sum([ViewPO-SF].[Form]![TotalPrice])

However, on load, the control displays '#Error'.


I'm probably missing something relatively simple, however its avoiding me at the moment.

Someone save me?

Thanks in advance!

Tom

 

[missinglinq]

This link addresses this exact problem:

http://support.microsoft.com/kb/208998

Linq ;0)>

 

[tinyevil777]

Easy as that, thank you very much! Perhaps should have done abit more digging before i posted... Apologies.

 

[missinglinq]

Glad we could help!

Linq ;0)>