I have a excel worksheet contain data of sales persons as under
Staff_Code Staff_name Cities Sales_Figure
124 Suman Mumbai
124 Suman Pune
124 Suman Kolhapur
124 Suman Nashik
128 Raj Thane
128 Raj Panvel
128 Raj Nagpur

Having one userform with two Combo-box.. If I select the Staff_code from Combo-box1 then row-source of Combo-box2 automatically update with Cities column. E.g if I select staff_code 128 from Combo-box1 then Combo-box2 populate the values with cities name like Thane, Panvel, Nagpur vice a versa. And same I want to do this with SQL query.
Please guide me on same.