Listbox name lookup

[jonh]

If you mean you want to filter the list just use like and wildcards

"WHERE [Full Name] like '*" & Me.TextSearch.Text & "*' Order by [Full Name]"

http://office.microsoft.com/en-gb/ac...005188185.aspx

You will need an event handler or button to update the list when the user has done typing,
List5.requery