I'm in a hurry so I'm sorry if I overlooked something obvious.
I haven't coded in Visual Basic for well over 5 years so I'm very rusty and I need to create a database frontend that allows a user to see a table in a .mdb and also search through the columns.

So I do the following:
1)New Project and add the mdb and table as a data source.
2)Drag the table into the form and use the query builder to create a search for the Title Column by adding (WHERE Title=?) or (WHERE Title like ?)

However when I use the search query, it'll only show results that match exactly whats in the search box. I need it to display similiar results as well.

eg: If I type in Harry Potter, I need it to show three different Harry Potter Titles. If I type in Tolkien I need it to show results for JRR Tolkien as well.

How do I set this up? It's probably something obvious but like I said I was in a hurry so I possibly overlooked it.