Summing A Subform Item

[jesusoneez]

I'm having trouble with a text box, which is trying to sum some date in a subform. All I get is #Error, yet I'm sure I'm referencing the item in the subform OK. I've attached the database as it's self explanatory (I stuck a label on it).

The form I'm having trouble with is frmPurchaseOrdersDataEntry and you'll see what I'm getting at from there.

Any help most appreciated.

Ste

 

[Meltdown]

you must do the calculation in the subform and then set the text box on the main form to the subform textbox value.. see attachment

 

[jesusoneez]

Thanks. I had tried something similar but just ended up with more #Errors...I was on the right lines but couldn't reach the finish.

Thanks again.

Ste