Calculations in subforms

G

Graeme at Raptup

Hi,
I have a form with 2 subforms.
Job (Main form)
Quote (1st subform)
Cost Details (2nd subform)

In the Cost Details (datasheet) I have as calculated:
CostAmount = ([CostPrice]*[Units])
LineCost = (([CostPrice]*[Units])*(1-[CostDiscount]))

In the footer (not visible) I have;
SubTotal = Sum((([CostPrice]*[Units])*(1-[CostDiscount])))

Now I'd like to get the SubTotal for each QuoteID (in the 1st Quote subform)
visible for each record in the 1st subform.
I know how to enter it onto the main form as;
Quote SubTotal = [frm_CostDetails Subform].Form! SubTotal

But I want to have the field in the 1st subform.

And then I want to have a Job_Total calculation on the main form that sums
all the quote sub totals.

As always, any help is much appreciated!
Graeme
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subforms within a Tab control 4
Populate main form from subform record 0
update textbox with total 9
Repeating a row other than the 1st row as the header row in a table from next page 1
calculations between subforms 1
Continues Subforms Scrolling 2
Validation rule using calculated value from another subform 3
textbox event 2

Top