Calculated Fields

[MsDYJ]

I'm trying to have a running total appear in a form. What I have is a main project form, and a tab control with 4 subforms. 2 of the subforms contain costs for resources and materials. What I want to happen is this: When the cost and qty. of a material and the cost and hours worked of a resource are inputed, the actual cost field in the main form should reflect the totals kind of like this Actual cost = (materialcost*qty) + (resourcecost*hrswrk).

I know how to do a calculated field in a query, but I'm having trouble doing so in the form. I'm not sure if it is possible but if anyone has any tips, I'd appreciate them.

Thanks!
MsDYJ

 

[MarkK]

I know how to do a calculated field in a query, but I'm having trouble doing so in the form.

In this case write a query that yields the desired results and set this as the new RecordSource of the main form. This is also more reliable in that it is not dependent on any other object.