I need help. How can I display the Total Amount and Net Amount on the main form? I am not able to do it. Please help. (2 Viewers)

moin555

Member
Local time
Tomorrow, 02:39
Joined
Feb 6, 2025
Messages
72
1753780799459.png

BOTH TABEL PURCAHSE AND SALE AMOUNT NOT ADD IN MAIN FORM PLZZ
 

Attachments

add a textbox called say txtSum to the subform footer with =sum(calculation) as the controlsource where calculation is however you are calculating the value (e..g =sum([quantity]*[price])

on the mainform, you reference it with =salesdetails.form.txtSum
 
View attachment 120686
BOTH TABEL PURCAHSE AND SALE AMOUNT NOT ADD IN MAIN FORM PLZZ
You appear to have a Control on the MAIN Form named "DiscountAmount" as well as a Control on the Subform named "Discount".

Do you want to calculate the Discount in the Subform and then display this on the Main Form as well?
 
View attachment 120686
BOTH TABEL PURCAHSE AND SALE AMOUNT NOT ADD IN MAIN FORM PLZZ
You would normally do the calculations in the subform as shown in the attached screenshot.

My apologies the Labels in the subform should be as follows:-
 

Attachments

  • Totals.png
    Totals.png
    22.5 KB · Views: 4
  • Sub.png
    Sub.png
    7 KB · Views: 4
Last edited:
Place a text box in the subform header with these properties
Name: txtAmtTotal
Control Source: =Sum([UnitPrice]*[Quantity]-Nz([Discount],0))

Then change the text box on your main form to:
Control Source: =[SaleDetails].[Form].[txtAmtTotal]
 

Users who are viewing this thread

Back
Top Bottom