Invoice Payment Subform

Invoice Payment Subform

Is it possible to use subforms to create a invoice payment form.

I am trying to import invoice details to a form with information about the invoice (e.g. invoice #, invoice amount, invoice due date) and then create a form where the user can enter select an account and view the invoices that need to be paid. They would then enter the payment amount and select the invoices to be marked as paid.

For example

Account:  XXXXXXX
Date:  07/20/13
Amount:  100.00

Invoice #      Invoice Due Date      Invoice Amount      Pay     
1123            07/31/13                  25.00                  25.00
1434            07/25/13                 100.00                  75.00