Ask a new question

Advanced search ms access 2013

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 buttonImageWhich 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.Image

Hmm, this should get you started...

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

Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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.

Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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.
Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 14, 2025 Views 579 Applies to: