help with searching.
I am trying to populate the listbox with the title of the item that matches the search critera. For Ex. let say I am searching the movies that I own for all the movies that have a rating of R. Inside of my database is 3 different tables one for movies, books and cds. All of the tables have similar fields like title, AuthorArtistStars, genre, type, status, discription, etc.
I want to be able to search each one of those columns for a part of the string that is contained in the field.