Main Form and Subform Totals

[NickFazer]

Hi


I have a Main Form that has information about contracts, one of the fields is ContractQty, linked to this is a subform based on a query that enters receipts against the contract and in the subform footer there is a field that totals the receipts.


What I want do is display the contract balance on the Main Form by subtracting the total receipts in the sub form footer.

Is this possible?

 

[NickFazer]

Sorted it.

 

[Gasman]

It would be nice if you explained how you sorted it, so that it might help someone else in the future?

 

[bob fitz]

It would be nice if you explained how you sorted it, so that it might help someone else in the future?

I would agree wholeheartedly with that.