Trying to write value of a calculated field on a subform to a field in a table
Posted on 2013-06-17
I have a form bound to a table. On the form is a subform with a calculated field. For now the field is named Text59. When the main form closed I have this code in the onclose event but it isn't working. I get a message that says it can't find the subform.
Here's the code:
CurrentDb.Execute "Update tblProjectBudgetHeader set ConstructionBudget = " & Forms!subfrmProjectBudgetDetails.Text59 & " Where ID=" & Me.Combo113.Column(0), dbFailOnError