I have spent much of today trying to create a subtotal in a subform then displaying it in my main form I have tried almost every suggestion on here and I keep getting a name error on the main form... I know the reference is spelled correctly
in my subform I have in the form footer a textbox with the following in the control source:
=Sum([OrderQty]*[OrderPrice])
in the main form I have the a textbox with the following in the control source:
=[Forms]![frmCreateInvoiceSUB]![OrderSubtotal]
I took this directly from the microsoft site so I don't know why it isn't working....
in my subform I have in the form footer a textbox with the following in the control source:
=Sum([OrderQty]*[OrderPrice])
in the main form I have the a textbox with the following in the control source:
=[Forms]![frmCreateInvoiceSUB]![OrderSubtotal]
I took this directly from the microsoft site so I don't know why it isn't working....