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!
--
Thank you! - Jennifer

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?
--
Thank you! - Jennifer


"Jennifer Cali" wrote:

> 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!
> --
> Thank you! - Jennifer