Calculated total in main form which totals a subform

G

geeves1293

I cannot seem to get a total from a subform.

This is what I've done.
text box in footer of subform which says =[Quantity]*[Lineprice]
textbox in detail of main form which says =[SubformTotal]

All I get is error or Name?

Can anyone help please.

Regards

Geeves1293
 
K

KARL DEWEY

Is your textbox in the subform footer named [SubformTotal]?
Try this --
[Forms]![YourMainFormName]![YourSubFormName]![SubformTotal]
 

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

Populate main form from subform record 0
DLookup in Continuous form 0
main form totals fail when subform total is null 5
Main Form / Subform Totals 3
Conditional Totals in Subform 0
subform total behaving strangely 2
Subform Totals 4
Total Detail on Continuous Form 5

Top