Hi Tinbendr,

Please help me with code line. I am bit confused. According the following code line should be used for populating countries in listbox1

[VBA]sSQL = "SELECT DISTINCT Country FROM Region_Mapping WHERE Country = '" & ComboBox1.Value & "' "[/VBA]

Can you please help me in replicating above code in such a way that the listbox get populated with countries on the basis of region selection.
for e.g. If I select America in combo box then it should show Brazil, Argentina, USA and Mexico countries which are mapped against america in sql table.

Thanks for your help in advance.