I have created a text box on a form which sums a contract value from the values in a subform. It all works correctly and me the right answer. However i need this figure to be then stored in the underlying table for use in related queiries and forms. Is this possible? Please Help

Alex

Yes it is possible but not recommended. Can you not put the calculation in the query

why is it not recommended mate?

Data integrity is the short answer.