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]
 
Top