Pulling Totals From One Form to Another

Topic

New Reply

I have an “Invoices by Student Subform” which shows details of invoices for that Student. It shows the InvID, InvDate, Invoice Total, Total Payments, and Amount Due. The problem is that I have a “frmInvoices” that you enter in the details of the invoice, and it shows the total of the invoice in a “frmInvoiceDetails subform”. The total payments are on the “frmInvoices” and so is the amount due.

So how do I pull the different totals into my “Invoices by Student Subform”?

Jen

Reply | Quote

Replies

You talk about pulling information from different forms, but that’s not really what you need to do. You just need a query for [Invoices by Student Subform] that pulls the information you want. Try doing a select query, then select the Sum button and group the information by student and invoice. This query will be the recordsource for your subform.

Reply | Quote