After I enter numbers into one subform how can I update info in another subform that performs a calculation based on that entered data? I want the calculated field, based on a query, to update in the "after update" event of my data entry field.
I have a subform based on a table to enter some numbers. I have another subform in the same main form that is based on a query. Subform no. 2 calculates the sum value of the numbers entered in subform no1. I have tried using code on the subform no. 1 field and on the subform itself to update the calculation in subform no 2. in the afterupdate event for subform no 1 data. I keep running into errors with trying to reference the control, form field or underlying query.
I've heard of "screen.active form" Is this something I need to use or not? If so how?
I have a subform based on a table to enter some numbers. I have another subform in the same main form that is based on a query. Subform no. 2 calculates the sum value of the numbers entered in subform no1. I have tried using code on the subform no. 1 field and on the subform itself to update the calculation in subform no 2. in the afterupdate event for subform no 1 data. I keep running into errors with trying to reference the control, form field or underlying query.
I've heard of "screen.active form" Is this something I need to use or not? If so how?
