How to Create a Search-As-You-Type Box in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to create a search-as-you-type box for your Microsoft Access forms.
Benjamin from Euclid, Ohio (a Platinum Member) asks: Is there a way to create a search box in my customer list form that allows me to quickly find a customer by their first or last name? Ideally, I'd like to start typing the first few characters and have it immediately direct me to that customer, similar to how a Google search begins showing results before you've finished typing. Is such a feature possible in Access?
Silver members and up get access to an Extended Cut of this video. Members will learn how to create a single text box to search on any field and have the results automatically update every time they press a key. Will make a button to clear the search box.
MEMBERS-ONLY EXTENDED CUT VIDEO:
• Search As You Type MEM...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/SearchAsYouType
PREREQUISITES:
Find Record: 599cd.com/FindRecord
Aggregate Query: 599cd.com/Aggregate
Null: 599cd.com/Null
Double Double Quotes: 599cd.com/DoubleDouble
LINKS:
SQL with Access: 599cd.com/SQLwithAccess
RECOMMENDED COURSES:
Access Search Seminar: 599cd.com/SearchSeminar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, search as you type ms, search while typing, instant search results, search textbox, search-as-you-type
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@kerrywsmyth]

I might be purchasing that seminar

[@vikvaporu]

Friend, your videos are incredible and I have learned a lot from them! Right now I have a form with many comboboxes which is used to capture the ambulance medical care record, one of many comboboxes is to write the emergency street (which is taken from a table where all the streets are stored ) but the combobox when writing searches from left to right, I would like to be able to write "str" ​​and filter the results and richard rost street appears, in the same combo box and not in a separate textbox since there are thousands of streets and sometimes it is Difficult to search for them manually since they are registered in a different way or with abbreviations. I hope you can help me

[@talen671]

This is a great video however my combo box doesnt work. I do have a form pulling from two different tables and I do not have that option. How do I create a search query with multiple tables linked in one form with the combo box? Also, I literally have started expanding my knowledge of access because of what you have taught me. Awesome work!

[@talen671]

Also, are combo boxes good for listed data only or can I use it for one date view searches? For example, I built a form from two different tables that only shows one set of information that has relationship to one primary ID. I would like to have the search combo box auto fill but because its not bounded to the form I'm searching for it does not do any searches. I hope I am making sense.

[@brysonwest93]

This was great, thanks. When I tried to add my combo box, I did not have the option to find a record as I typed, as shown in the video. Microsoft research indicated that my form had to be 'bound.' I was confused because my form was bound but I still didn't have the search option. Turns out I had to set my data source to just the table that the form was bound to. I could not have an SQL statement in the bound form with sorts, etc. It had to be bound directly to a table. Hope this helps others. Thanks again Computer Learning Zone!

[@599CD]

I believe I mention that in the video

[@RafaJach-dd4my]

Please make a query to COMBO by surname and first name -------- SELECT tblModels.IDModel, tblModels.Surname FROM tblModels ORDER BY tblModels.Surname; add a name to it ??? please