I have a problem today with Access 2003.


There are three forms: MainForm, SubForm (in MainForm), SubSubForm (in SubForm).

The relationship is Mainform-Subform (1-n), SubForm-subsubForm (1-n)
I need to get subtotal of subform on Mainform. (I created sum_Subform in footer in Subform, use SubForm.Form!sum_SubForm in Mainform to refer to the total.) This is working fine.

Then within Subform, I need to get subtotal of subsubform for each line(datasheet view with expansion of subform) . (I created sum_subSubform in footer in subSubform, use SubsubForm.Form!sum_SubsubForm in subsubform to refer to this total.) The weird thing is that it shows the same sum_subsubform for all rows in subform, which equals to the total of first record in the subform.

Anyone know why this is wrong?
Thanks