hey everyone. I have 2 combo boxes. One displays the product id and other displays the contracter id. I would like to design it in a way such that when the user first selects the product id, the contracter combo box would only display the contracters for that particular product id. I used a query for the combo box where the it would only display the contracter for the product id selected.
Example data
product id contracter id
1111 aaa
1111 bbb
2222 ccc
The thing is the it works perfectly fine but only for the first time. Thus as soon as the form with the two textbox opens and I select 1111 as the product id , both aaa and bbb is displayed in the contracter combo box which is correct. However, when I change it to 2222, it still displays aaa and bbb for the contracter combo box.
Hope someone can advise me on what I might be doing wrong.
Thanks!