Sub From Totals

[Katana2003]

I have two sub forms on a header form. On one of the sub forms there are two sub total fields I need to put the total of these two fields into a total field on the other sub form. How can I do this?

Thanks.

 

[TelcoBT]

One way is,I think, a matter of knowing the hierarchy of the sub form fields then setting the 'total field' to the sum of them,

eg

=[forms]![myParentForm]![subForm1]!subTotalField + [forms]![myParentForm]![subForm2]!subTotalField

(my syntax above is probably not accurate, as Access isn't my main skillset and I've not got Access or any of the apps on my current PC to check.)