AnsweredAssumed Answered

Error Message of invalid qualifier: in VBA 6.0

Question asked by MLCouden on Apr 4, 2013
Latest reply on Apr 4, 2013 by bruce.nielsen
I have code written for combobox and it is giving me an error of invalid qualifier. I am not understanding becuase I have declared the variable. Please help!

[/CODE]
Private Sub cboStations_Change()

      Dim cboYear As String
     
      If cboStations.Text = "Urban" Then
          cboYear.Clear >>>> Right here is where I get the error>>>>>
      cboYear.AddItem "2010", "2011", "2012"
      End If
     
       
       
End Sub
Private Sub cboYear_Change()

     Dim cboDistrict As String
    
     If cboYear.Text = "2010" Then
          cboDistrict.Clear
     cboDistrict.AddItem workRecSet("Abilene", "Amarillo", "Austin", "San_Antonio", "Waco", "Wichita_Falls")
     Else
     If cboYear.Text = "2011" Then
          cboDistrict.Clear
     cboDistrict.AddItem workRecSet("Beaumont", "Houston")
     Else
     If cboYear.Text = "2012" Then
          cboDistrict.Clear
     cboDistrict.AddItem workRecSet("Brownwood", "Bryan", "Childress", "Corpus_Christi", "El_Paso", "Lubbock", "Odessa", "Yoakum")
    
     End If
[/CODE]

Outcomes