Code in wrong place

[nim180]

Hi everyone,

I have the following code in the control source of a textbox on the mainform

=[Forms]![frmWorkshop]![frmSubMaterials].[Form]![Total]

This gives me the total cost of the field "Total" in the subform. What i need to do is place the code somewhere else besides the control source of the textbox because i need to save the figure into my table. Can someone tell me where i can put this code and still be able to save the value. Any inputs or there diferent methods people have would be great.

Regards,
Nim

 

[MajP]

Most people do not save calculated values in a database. If you can calculate it on a form you can do the same on a report , query or anywhere else you want to show it.