Combo Box Filter

[sajidraza]

Dear Fellows hope you are all fine and doing well, i am new use of access i need you help

I have a form and i want to filter data by combo box. Values of combo box has selected from another table (Supplier). How can i get all data entries against one supplier by selecting the supplier from combo box. How can i link the data between combo box and table

 

[CJ_London]

you need to provide more information about what you are trying to do, there are a number of different ways it can be done, but all depends on how you want it to work. So we will just be speculating which is the right one for you.

How can i get all data entries against one supplier

what does this mean? all invoices/purchase orders/payments/contact details/delivery addresses/etc?

What are your control, table and field names?

What is the rowsource and bound column to your combobox?

a simple answer is in the combobox after update event put

 me.filter="SupplierPK=" & cboFindSupplier
 me.filteron=true

changing names to match your field and control names but no idea if this is appropriate to your needs.