Calculated Text Box

[alxj]

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

 

[Richie]

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

 

[alxj]

why is it not recommended mate?

 

[Richie]

Data integrity is the short answer.