Creating Multiple Payments for One Invoice (utilizing a subform)

[BrittKnee]

Hi! I have an existing database and the users are requesting to restructure how payments are recorded. I am updating the database to give the user the option to enter more than one payment per invoice. I have set up a payment table with the following fields:

PaymentID
InvoiceID
Payment_Date
Payment_Type
Payment_Amount

I need to populate the InvoiceID into the payment table as well as display other pertinent data from the invoice query (total due, discout %, etc.). I am attempting to do this using a subform, but am running into issues. I have also tried creating a combo box to select the InvoiceID and enter the payment data. I have attached a screenshot of the form. Any help will be greatly appreciated. Thanks.

[Micron]

I see no navigation control on your subform so there's really no way to navigate from one payment to another for a given invoice. Either enable or switch to a datasheet for the subform. You need InvoiceID on the main form and the subform and set the Link Master & Child fields property for each invoice id control. If you use a combo to filter/find an invoice, don't bind the control (it should not have a recordsource property). Showing id values is ok when developing but usually they are not shown to users. If they are numbers and not meaningful data, those values mean nothing to the user and usually only add confusion.

[orange]

See this info and model from Barry Williams' site for additional info

[BrittKnee]

Thanks for all of your input. I was able to resolve this issue. Just needed to use VBA to refresh. Thanks again.