Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pulling Totals From One Form to Another

    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

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Pulling Totals From One Form to Another

    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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •