We help IT Professionals succeed at work.

search field in access 2010

Hello
I want to add a search field in the access file . that when i enter a letter it should appear for me a list with student names with the contains that letter .(like google). and i choose the name to modify it .

Please find the attachment for the access 2010 . i want to add the search in the student form .

thanks alot
Student-DB.accdb
Comment
Watch Question

Commented:
in the query use like '%search cretiria%'
See attached Search Module that I have created. You might get ideas from it and apply those to your application.

Sincerely,
Ed
SearchDB.accdb
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Let me suggest that everyone read this excellent article by Marcus Fischer (Harfang) which exactly addresses this subject.  State of the Art techniques are exposed here. Sample db is included!


Search (While You Type) in a ComboBox
http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_6490-Search-While-You-Type-in-a-ComboBox.html

And for further education ... read the 3 part related series, which starts here:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_6069-Using-a-Criteria-Form-to-Filter-Records.html

mx

Explore More ContentExplore courses, solutions, and other research materials related to this topic.