Hi,
I'm using the below code dependent combo box but when i opens file getting error msg "compile error method or data member not found".
Please help. Thank you in advance.
Private Sub ComboBox1_Change()
If Me.ComboBox1.Value = ALL_INDIA Then
Me.ComboBox2.Value = ""
Else
Me.ComboBox2.ListFillRange = Me.ComboBox1.Value
End If
End Sub
Private Sub ComboBox2_Change()
Me.ComboBox3.Value = ""
Me.ComboBox3.ListFillRange = Me.ComboBox1.Value & Me.ComboBox2.Value
End Sub
Private Sub ComboBox3_Change()
Me.ComboBox4.Value = ""
Me.ComboBox4.ListFillRange = Me.ComboBox3.Value
End Sub
Bookmarks