Hi there, I am using the following code to query the value of a dataCombo box

Dim SQL As String

Private Sub DataCombo1_Change()
On Error Resume Next
Adodc1.RecordSource = SQL & "'" & DataCombo1.Text & "'"
Call Adodc1.Refresh
End Sub

Private Sub Form_Load()
SQL = "Select LELyear, UELyear FROM Limits WHERE TaxYear = "
End Sub


When I click on a TaxYear in the dataCombo, it returns the correct year, but then if I decide to change the year, the dataCombo is empty?

I have the dataCombo's RowSource set to Adodc1 and it's List Property to TaxYear.