But I can't seem to find it.. I am using a datagrid control accessing an access database using the Jet 4.0 engine. Basically I have a database with my music, and I want to be able to search using a textbox on the form, by either title or artist. I want the searcher to be able to put in part of the title/artist and get all results with that text in it listed in the datagrid.

datagrid is defined as dgall
ADO control is defined as adMP3
textbox is defined as txtsearchstring
command button to search is defined as cmdSearch
title field is defined as title
artist field is defined as artist
form is defined as frmMaster
project is defined as dj

What would be the code to accomplish this. As you can tell, I am a fairly new programmer, second year doing it, but fumbling still.

Thanks for the help in advance!

Alan Reid