Advanced search ms access 2013

Question

I want to create an advanced search button that is connected to a dialogue form that searches for a specific criteria. When the user enters the criteria they don't have to press anything the matches just come up something like the following, where the original form has a advanced search buttonWhich then goes on to produce a connected form that shows the criteria and related records according to the letters of first and last names of the people in the database.

Answer 1

Hmm, this should get you started...

https://blogs.office.com/2012/05/03/using-a-combo-box-to-search-as-you-type/

Answer 2

I dont want a combo box though I would like a text box that users can enter values into

Answer 3

Hmm, them something like...

Dim strSQL As String

        strSQL = "SELECT YourField, YourField " & _

                        "FROM YourTable " & _

                            "WHERE TheFieldYouWantToSearchOn Like '*" & Me.NameOfTheControlOnYourForm.Text & "*')) " & _

                                "ORDER BY FieldFromYourTableOptional DESC"

In the On_Change Event of your Text Box Control on your Form.

Answer 4

Ivy, Why not use a combo? the user can still just type what they want, but using a combo can ensure they type a valid value. Plus the combobox wizard will create the search control for you.