Noe
10-18-2001, 10:32 AM
I am trying to store a calculated figure in one of my subforms to the table corresponding to the subform. I Know that I shouldn't do this but I want to anyway. Does anyone know how to do this?
|
View Full Version : Calculations from form to table Noe 10-18-2001, 10:32 AM I am trying to store a calculated figure in one of my subforms to the table corresponding to the subform. I Know that I shouldn't do this but I want to anyway. Does anyone know how to do this? Travis 10-18-2001, 12:27 PM You will need to place code on the AfterUpdate Events of each field that makes up the calculation. This code will set the field = to the calculation. example: Me.Form.[Subformname].Field("YourSubFormFieldName") = Me.[CalcField] |