Calculated total in main form which totals a subform

G

Guest

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
 
G

Guest

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

Main Form / Subform Totals 3
PROBLEM: Subform total on main form returns #Name 5
Delay in getting subform total to calculate 2
Subform Totals 4
Update subform with combobox change on main form 1
Total Detail on Continuous Form 2
Subform total on Main Form 7
numerical summation to passed from sub to main form 2

Top