How can I refer to control that located on form, from subform?
You can not directly. The subform knows nothing about the form so can not update it. If you want to update a subtotal on the main form you have three options. 1) Use the timer function to call calcfields or update a variable. 2) use the on deactivate of the subform control to calcfields or update values on the header. But this only works when you deactive the subform. 3) design the subform in such a way that the totals are on the subform. turn the outline to off on the subform control and you can not tell! Paul Baxter Edited by - triff on 2002 Jan 08 12:54:19