sub form field reference problem

[ascheper]

I'm having difficulty saving the contents of a field on a sub form to a field on the main form. The field on the sub form is a calculated total which I want to save in the recordsource for main form. The sub form is a datesheet that displays a customers ordered items. the name of it is OrderSub and the fields are 'ProductNo', 'Price', 'NumberOrdered', a calculated total on 'Price' and 'NumberOrdered', and, the field I want to save, another calculated total 'TotalField'. On the main form called 'OrderMaster', the total from the sub form is displayed using the following: '=[ordersub].[form]![TotalField]', this field being called subTotal. I tried to reference that control (on the main form) through the OnCurrent and AfterUpdate events with 'me.GTotal = subTotal', and only get $0.00 in the field I want which is GrandTotal. I'm stumped, any hepl would be greatly appreciated. BTW, I'm using an Access project to connect to a SQL server 2000 datebase.

Thank you

Andrew