I created a unbound textbox to search one of the tables, it works well for one search. But the problem is usually, users would type in more than one search terms, and I would like to make it possible to retrieve records if any of the search term matches. For example, if I have a name record, "Thomas Smith", for now, it is okay for me to type in "Thomas" or "Smith" to get the record. What I want is if users type in "Thomas Johnson" or "Joe Smith", they can still retrieve the record "Thomas Smith". Is it possible to do that? My search code has been: Like "*" & Me.[textbox] & "*" Thanks a lot!