Populate a Parent form field from subform total

[gg80]

I have a continuous subform with a list of items that are be selected with check boxes. A header control called “AddersTotal” shows the sum of the value of the items selected. On the subform After Update event, I would like the "AddersTotal" to populate a field in the parent form called “Accessories “ so that I can store the value and use it other places.

I have tried the code me.parent.Accessories=me.AddersTotal for the After Update event of the subform. The field Parent.Accessories will show the old total, not the new total. If I precede the code with Form.recalc, the Parent field shows 0. At times, I get an error message “data has been changed” .



I must be missing something fundamental about what “After Update” means. I have searched on the web but found only one lengthy discussion that ended in failure plus some things that make me think that the above should work. Any help much appreciated.
I am using W7 with A2007

[slave138]

I would probably put the code into the OnClick event for the check boxes. Check the value of the checkbox to determine if it is selected or not, then adjust the totals and update the parent.

If you want to upload a sample version of your DB I can probably help you solve your problem.

[gg80]

Hi and thanks. I seem to have had some other problems with the form, but once straightened, I started code from the check box and works consistenly now. I have a quantity item that changes the total also. For that one, for some reason, I have to put a form.recalc and a form.refresh in front of code or I get the error message that data has been changed. Thanks again