Hi everybody.
Please help me on following syntax error.
I am using a string variable as RowSource of combo box: cmb_unit.
As you can see in the attached image it has syntax error and I couldn't figure it out.
I appreciate your help.
Please help me on following syntax error.
I am using a string variable as RowSource of combo box: cmb_unit.
As you can see in the attached image it has syntax error and I couldn't figure it out.
Code:
Private Sub cmb_items_AfterUpdate()
Dim sSource As String
sSource = "SELECT t_units.[unit_ID], t_units.[unit], t_units.[unit_index] " & _
"FROM t_units " & _
"WHERE t_units.unit_index= " & Me.cmb_items.Column(2)
Me.cmb_unit.RowSource = sSource
End Sub