ACCESS FEED: [MS_AccessPros] Filter List Box through Text Box

Kamis, 01 Desember 2011

[MS_AccessPros] Filter List Box through Text Box

I am trying to filter list box through my text box as I data change in text box the code is as following but its not working what am I doing wrong

Private Sub Text2_Change()
    Dim strsql As String

    strsql = "SELECT ID, EmpName FORM tblName WHERE EmpName Like '*" & Me.Text2.Text & "*'"
    Me.List0.RowSource = strsql

End Sub

Thanks & Regards,
--
Abdul Shakeel

[Non-text portions of this message have been removed]