Lynn,
It sounds like everything is working correctly! I'll give you a example of how this could work. In my sub form I have a field named "Parcels" in the sub form’s footer I have a unbound textbox called Text14. In the control source I have this calculation.
Code:
=DSum("parcels","tblpurchdata","warehouseid=" & nz([warehouseid],0))
Ok now on the main form I have another unbound textbox called "txtTotals" in its control source I have this calculation
Code:
=[Form2].Form!text14
Text14 does the calculations [hidden btw] while txtTotals displays it constantly I hope this sheds a little light on how you can calculate on the fly so to speak...and never never try to save this to a table they are for reports or forms. Me.Requery in the forms after update might help also.
Regards,
Richard