Saving multiple combo box results

I have a form that is bound to a table. The form has 3 combo boxes. After selecting an option on the 1st box it filters the options in combo box 2 and so on. The problem I ran into is that the table is saving the ID # which is column 1 in my combo box. I want it to record column 2 which is text. I tried changing the bound column field to 2 but a enter parameter field pops up.

this is what I have:

Option Compare Database
Private Sub cboCategory_AfterUpdate()
Dim sType As String

sType = "SELECT [Type].[Type #], [Type].[Type] " & _
"FROM Type " & _
"WHERE [Category ID] = " & Me.cboCategory.Value
Me.cboType.RowSource = sType
End Sub

Private Sub cboType_AfterUpdate()
Dim sItem As String

sItem = "SELECT [Item].[ID], [Item].[Item] " & _
"FROM Item " & _
"WHERE [Type ID] = " & Me.cboType.Value
Me.cboItem.RowSource = sItem
End Sub