Hi Tinbendr,

Thanks a lot for replying on my post. I have just now checked the file attached by you. I didn't find any sub routine in module1 as mentioned by you in your recent post. Apart from this We I try to run the form it shows me the following error.

[VBA]Run-time error '-2147217900 (80040e14)'
Incorrect syntax near ')'
[/VBA]

When I click on debug after facing the above error. It highlights below line

[VBA]Set rst = .Execute(stSQL)[/VBA]

Though when I debug it highlights above line but I think there is something wrong with the below sql statement.

[VBA]stSQL = "SELECT DISTINCT CONVERT(VARCHAR(50), " & ComboBox1 & ") FROM Region_Mapping"[/VBA]

I am re-attaching the macro file and the sql table Region_Mapping which I have copied into excel.

Thanks a lot for your help in advance.