Results 1 to 2 of 2

Thread: Search Function from a User Form
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2017
    Posts
    483
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Search Function from a User Form

    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!

  2. #2
    Board Regular
    Join Date
    Mar 2013
    Posts
    793
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Search Function from a User Form

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •