thanks. for you reply also...
how can i have the result showed in the 2nd Combobox without having to use the little down arrow to select it. as there will be only one result. after selecting the First Combobox critera. example if i change my selection in the first combobox i want the result to display in the window of the second combobox without having to use the down arrow to change it >? thanks
Another way for your first question, you can try this on the click event in the combo :
Combo.Value = Combo.Column(0, Combo.ListIndex) _
& " " & Combo.Column(1, Combo.ListIndex)
Or in the same event you can select the row of your second combo.