Compile error method or data member not found

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

Please include the rest of your code.

What is ALL_INDIA? I don't see any variables declared? Is it a named range?