Search Function from a User Form

[reberryjr]

I'd like to have a form with some and/or search options. When the User clicks "Search", the results are displayed in a form, with a Next button that allows them to move to the next search result. The workbook is entertainment related, so the search form would have options like "Actor", "Director", "Genre". If the User either enters or selects (from a drop down) "Horror", I'd like the first instance to pull up in a different form, that has a Next button and eventually a List button that shows all results in a list.

I've searched through a few books I have, some forums and Google, but haven't found the answer that I'm looking for. Does anyone have any resources that would direct me towards the solution?

Thank you in advance!

 

[NoSparks]

Don't know what you have towards this already but...
I think if you were to use the word filter rather than search and display in a list box instead of pull up another form
you would be more successful Googling for assistance.

Suggest starting with just a drop down Combobox and a Listbox on the user form and grow from there.