Aggregating Values from Separate Tables in One Query

[Guest]

Hello,
I have four tables: tblEvent, tblLighting, tblAV, and tblScenic. Each table
has a corresponding form frmEvent, subformLighting, subformAV, and
subformScenic (the sub's are all subforms in the main frmEvent).

The three subforms are set up as datasheets with a SUM function in the
footer of each form...the forms track the total cost of AV equipment,
Lighting costs, and scenery costs for setting up local plays. I want to have
a display tab that shows the total project costs by category but don't know
how to accomplish this. Would it be through a query which would become a
subform shown as display only values?

Please let me know if this doesn't make sense and I'll try to explain
better. Thanks!

 

[Guest]

Ok, I actually figured that out. Now my issue is that the calculated values
on the subform "subformTotalCosts" don't actually autocalc until you scroll
to a different record & come back OR close the form & reenter. How can I
correct this?