I want to set up a Search facility in my database that functions as below:- Users enter a search term into a text box on a form then click a command button to perform the search. All fields within the table are searched to find the keyword (search any part of a field not whole field). If the keyword isn't found, a message box should display saying the usual "No results found". Or if the term is found, then the results are displayed in a subform on the same form, along with command buttons to allow the user to view or print that record. What I need help with is the query/code that is required to get this initial search working and how to display the results in a subform. I am comfortable with creating the code to filter records for viewing. Any help would be greatly appreciated.