Creating a search box with Radio buttons

[jmeddaugh]

Hello!
I have been beating my head against a wall trying to figure out a way for get this search to work.
I have created a movie "box" and would like to search for movies based upon actors, year, genre, and of course title. I have the userform created, but am having difficulty getting the search box to work.
Any help would be greatly appreciated!!

Thank you!!

[skywriter]

You can try this. I did some light testing on it.
Check the spelling in the name of the titles option button. I changed that in the attached file. If you are not going to use this file you would need to address that.

Please Login or Register  to view this content.

[jmeddaugh]

Thank you Skywriter! It works great, exactly what I was looking for! You are the best!!!

[jmeddaugh]

It there a modification to the code that would search for any part of the criteria? For example if I put in "Rush" it would list Rush Hour, Rush Hour 2, and Rush Hour 3.

Thanks again, you have been a great help!