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 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..