Hi John, I am using your dynamic multiple search to build a book database for me and my boyfriend. We are both teachers and we have loads of books to help with our job. Anyway, my search is more complicated with more criteria, so instead of listboxes, I made Combo boxes and everything works out fine. my only problem lies in the Search Query. For some reason, when it runs, a box says "Enter Parameter Value" for each of the criteria. I checked so many times and I am sure that I got everything right. Even though I am new to Access, your sample was very helpful and helped me understand it a bit better. I don't know why it doesnt show a table that combines the info of the other tables. please help me. Thanks so much. You're a star.