hello dear hope you are good I want to add the total bill amount in the header. How can I do it?

[moin555]

 

[bob fitz]

Perhaps the same expression that you have used in the Footer would work in the Header

=Sum([BillAmount])

 

[CJ_London]

Try

=subformname.form.controlname

Change names to suit. You might find this link useful

Forms: Refer to Form and Subform properties and controls

 

[arnelgp]

Control Source:

=[Form]![Invoice_Subform]![txtTotalBillAmount]

 

[moin555]

Control Source:

=[Form]![Invoice_Subform]![txtTotalBillAmount]

not working

 

[moin555]

not working kindly check

 

[moin555]

Perhaps the same expression that you have used in the Footer would work in the Header

=Sum([BillAmount])

not wokring sir

 

[bob fitz]

try:

=[CreditInvoices_Subform].[Form]![Text25]

 

[bob fitz]

I would change the name of Text25 to something that has some meaning E.g. txtInvTotal

 

[moin555]

try:

=[CreditInvoices_Subform].[Form]![Text25] kidly check file shared

 

[bob fitz]

Try this:

 

[moin555]

Try this:

Thank u sir for your kind help . I am Trying on it

 

[arnelgp]

=[Form]![CreditInvoices_Subform]![Text25]

and also on Property->Format->Format: Standard
to show the commas.

 

[Pat Hartman]

If #9 doesn't work using YOUR control and form names, then you can "push" the value rather than "pull" it. Put your code into the After update event of the subform.

Me.txtTotalBillAmt.Recalc
Me.Parent!txtTotalBillAmt = Me.txtTotalBillAmt

 

[arnelgp]

Controls don't have Recalc method, only Forms.

 

[Pat Hartman]

I meant .Refresh. You need to force the control value update to happen before you can push the value to the main form.