cascading combo boxes - 1st one works - 2nd won't populate

[David30184]

I'm using three combo boxes - The second (cbosubSkillList) is limited by value selected in the first (cboSkillList). The third (cboSubSkillList2) to be limited by value selected in the second. The third will not populate - If I comment out the code, It WILL populate will all values, but will not populate with code active. All names, properties, etc. with combo boxes, tables, field names parallel - Why am I not populating the third box?

[Code]
Private Sub cboSkillList_AfterUpdate()
With Me![cboSubSkillList]
If IsNull(Me!cboSkillList) Then
.RowSource = ""
Else
.RowSource = "SELECT [SubSkill] " & _
"FROM SubSkillList " & _
"WHERE [SkillID]=" & Me!cboSkillList
End If
Call .Requery
End With
End Sub
*****************************
Private Sub cbosubSkillList_AfterUpdate()
With Me![cboSubSkillList2]
If IsNull(Me!cboSubSkillList2) Then
.RowSource = ""
Else


.RowSource = "SELECT [SubSkill2] " & _
"FROM SubSkillList2 " & _
"WHERE [subSkillID]=" & Me!cboSubSkillList
End If
Call .Requery
End With
End Sub

[John_G]

This statement:

"SELECT [SubSkill] " & _
"FROM SubSkillList " & _
"WHERE [SkillID]=" & Me!cboSkillList

is populating cboSubSkillList with one field - Subskill - which I assume is text, using the value in cboSkillList, which is numeric as selection criteria.

Now, the statement to populate cboSubSkillList2:

"SELECT [SubSkill2] " & _
"FROM SubSkillList2 " & _
"WHERE [subSkillID]=" & Me!cboSubSkillList

uses the value in cboSubSkillList, which is text, not numeric, to compare to an ID, so it wont work.

Try changing your first select to:

"SELECT [SubSkillID], [SubSkill] " & _
"FROM SubSkillList " & _
"WHERE [SkillID]=" & Me!cboSkillList

so that cboSubSkillList will have a numeric (ID) value. Set the width of column 1 in cboSubSkillList to 0 to hide it.

HTH

John

[David30184]

Will try this tonight and respond - Thanks John - seems I have Numeric trying to speak to text (??)