I have a form with a calculated field. When I close the form I want the value of that field to be written to a table field. The form uses the table as its record source.
The calculated field name is "txtTotOPcost". The field name in the table I want to write the value to is "TotOPcost". The table name is "tblMyEstimates"
I realize that it is not advised to capture calculated values but in this case I have to do so,