Creating a Query during run time??

[JamesC]

I'm attempting to create a shop register program for a music store which runs off a database storing all the music/stock information.
I'm trying to put in a search feature where you can search for a specific CD. So I've got a couple of text boxes where you enter in what you are looking for, but so far I've been unable to get my query to use the info from the text boxes and to display the results in a listbox when I click on 'search'. It works if what I'm searching for is hard-coded, but not when I try getting the info in the text boxes. Make Sense? Any Ideas would be great!
Thanks,
James

[clyde]

Why don't you filter your recordset based on the criteria.

eg. rs.filter = "Artist like '" & txtArtist.text & "' and Music = '" & cmbMusic & "'"

i did this out of my head so there might be something wrong. It is the idea that counts.

Clyde