Copy a number value to another field and sum the column

[scottappleford]

I have two sub forms and need one field to equal a field in another sub form.

When I enter data (a number) I would like the field in the other form to add up all the fields in the form I just enetered the data in.

Both sub forms are datasheets.

thanks