Solved MS Access Unbound Combo Box (1 Viewer)

[nector]

I want to use this unbound combo box on a subform for the purpose of looking up only because the same form support imported data, but when the users select the product name you find that that product name repeat itself in the second line which I do not want to see or happen. Any idea to stop this?

Here is the unbound combo box raw source

SELECT tblProducts.ProductID, tblProducts.ProductName, tblProducts.itemCd, tblProducts.itemClsCd
FROM tblProducts;

 

[Minty]

It's because it is unbound, you'll get the same data in each row.
On a datasheet this is quite messy to get around.

Have a search on the forum for potential solutions.

 

[nector]

Ok thanks minty