CODEWITHSUNDEEP
databasems-access
Fred Polli
Fred Polli

Reputation: 183

MS Access Filter options in combo box on subform in many-to-many relationship

I have an Microsoft Access database where I track invoices and payments. A payment can pay multiple invoices, and the payor can take multiple payments to pay one invoice in full. I am trying to make a form to use when the payor makes a payment. I need to be able to select previously existing invoices to attach to the payment record.

I have an invoices table, a payments table, and an invoice_payment table with the one-to-many relationships defined. I am able to make a payments form with an invoices subform in datasheet view that will allow me to create new invoice_payment records by selecting an invoice with a combo box. What I am completely unable to figure out how to do is to filter the options in the combo box so the person does not have to scroll through 3000 invoices to find the one they need.

I want to be able to filter my invoices by the Vendor name, then by the Invoice number to get the specific invoice to attach to the payment.

Upvotes: 0

Views: 28

Answers (0)

Related Questions