Why doesn't the third drop box work? Plese check

[spidalegz]

Private Sub Combo0_AfterUpdate()
Combo2.Requery
End Sub


Private Sub Combo2_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub Combo2_GotFocus()
If Len(Trim(Nz(Combo0, "&quot & "&quot) = 0 Then
MsgBox "Please Specify Make first"
Combo0.SetFocus
Else
Combo2.Requery
End If
End Sub


Private Sub Combo6_GotFocus()
If Len(Trim(Nz(Combo2, "&quot & "&quot) = 0 Then
MsgBox "Please Specify Model first"
Combo2.SetFocus
Else
Combo2.Requery
End If
End Sub

All i get are numbers...that arent the years i want

 

[spidalegz]

Also, check and tell me if this looks right

SELECT CLyears.id, CLyears.years, CLyears.frn_model_id FROM CLyears WHERE (((CLyears.frn_model_id)=Forms!Banner!combo2)) ORDER BY clyears.years;

will that get my "years," which are actual years, to show up according to the code above? From the combo box above it?