I made a combo box From which I select a table from my supplier database. The SQL coding of the RowSource is "Select product.code, product.desc from product where product.supplier = order.supplier into cursor cProductCombo order by product.code".

I found a problem that the data in the cProductCombo cannot change whenever the value of the order.supplier was changed.

Would you please give me any suggestion.