Calc total of two seperate subform tables

[ArthurSG]

Hello,

I've been searching through the forums looking for an answer and I seem to be stuck.

This should be an easy one for most of you.

I have a form with multiple fields and two subForms, these two subs are being displayed as a table. In these two tables i have an identical field "X".

basically i would like to get the subtotal of the entire field "X" for each table, then get the sum of both subtotals and display this in a textBox.

This all seems like such an easy problem to solve but its how to call certain properties that I'm really unfamilliar with. I am almost sure of the fact that this is going to have to run a query. I will continue my search on this.

Any help is greatly appreciated

Thanks,
Arthur

 

[ArthurSG]

I've have found the answer to my problem in the help > sample database.

I found that if you calc the subtotal in the footer of the subform and just reference that value in your form it works perfectly. also i can sum the two fields quite easily.

It was really just a matter of finding how to reference that field in the control source of my textBox.

Thanks,
Arthur