Can i get subform total on mainform

[muhammadirfanghori]

How can i get subform total on Mainform i have try many tricks but not work for me
i have attached sample database please any one can help ??



Invoice.zip

[June7]

Subform in design view, create a textbox in the form footer or header section that calculates the sum. Textbox on main form can reference the textbox, even though it won't display in the datasheet subform.

[muhammadirfanghori]

Can you explain in my sample database

[June7]

SubTotal field is defined as Long Integer. If you want decimals need to be Double type. Actually, SubTotal should not be saved into record - should be calculated when needed. Same for Amount in PurchaseInvoice.

Quantity field is set as text and must be number, long integer.

For some reason, the Sum() function still shows #Error in the textbox.

I don't understand why this fails. This technique has worked before. And I just tested again in my db and it works. Sorry, I don't know what is wrong with yours.


Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.