I am having trouble with Access displaying text on a main form...

I have a text box in the form footer of my subform which preforms a sum calculation of my transaction totals.

I have used the code:

=Sum([Unit Price]*[Quantity])

I then placed an unbound text box on my main form and usd the following control source to bring the subform total to the main form:

Controlsource: =[mysubformname].[form]![subformtotal]

This was the recommended pathway from Access Help. However, I am getting the error message "#NAME?" when I open the main form in
form view.

My question is two-fold:

(1) Is there something obvious I am doing wrong?

(2) Is there another way to get the subtotal from the subform to the mainform?

Any assistance would be fully appreciated..

I solved the problem so I don't need help... but thanks anyway...