Nested subforms

[elios11583]

hello everyone,

I am facing a problem with displaing a calculated value from a nested subform(B) on the subform(A) which is a subform of a main form (X).

i m calculating the Total in the nested subform(B) and i want to show the total on the subform (A).

when i open the subform(A), the value is always #error.
if i expand the nested subform (B) datasheet view, it updates.
if i expand 2 nested suforms (B), the value showing for all the Total records of (A) will be stuck on one subtotal value of (B).
if i go to another record on the main form, the values of total on subform (A) will all be just one subtotal value of (B).

any suggestions plz.

best regards