I have two comboboxes they are sync each other. After selecting first combobox value and then corresponding values will display in 2nd combobox . Each time when i select first combo box then previously reselected 2nd combo value should be clear. I'm using below code in the OnChange event of first combo1.But it is not working.
Private Sub combo1_Change()
Me.combo2.RowSource = ""
End Sub