Listbox name lookup

[claven123]

Added information:

The listbox is from a query named: QryListAll
the text box is: TextSearch
the field I'm attempting to filter by is: Full Name (it's in the QryListAll by conc. FirstName & LastName)

Hope this helps..

This is what I have so far....

Me.List5.RowSource = "SELECT Full Name FROM QryListAll " & "WHERE Full Name """ & Me.TextSearch.Text & """ ORDER BY Full Name"

I know the field name of Full Name is not good, but that is what I have for now... will it help to enclose it in []?

d