(adsbygoogle = window.adsbygoogle || []).push({}); I have been trying to solve this for ages and haven't got anywhere. Here is my situation:

I have two tables:




I have a listbox (ListBox3) that i need to populate.
I also have a dropdown combobox which is filled using a datasource and contains the StyleID from a different table to the one i want the listbox to be filled with.
I would like to use the dropdown to 'search' through the second table (tbProducts) and populate the listbox with the Product Name when the StyleID column matches what is in the dropdown.

I have tried simply using a query in the bindingdatasource of the listbox but because i want to use a combobox, it cannot be used in the query

If any further information is need i can provide it, not sure what else is needed but doesn't seem as though i have provided a lot

Any help is much appreciated, thanks!