I have a subform called "InvoiceDetailssubform" and a main form called
"invoices details"
in the subform there is a field Expenseitemamount
so to get total of this field ,i have places a text box in the footer of the
subform , which i called it "Expense Totals"
now i want to get this figure for each record of the form " invoices
details" but unfortunatley am i getting wrong figure , i get the total amount
of all records in the source table of the subform .
although i am using the same way in another main and subform , and getting
correct results.
what could be the problem, how can i make it to show only total amount of
the subform records the belongs to the current main form record only.

( note: the subform is showing the correct number of records, it is not
showing all records in the source table.)