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

[@kerrywsmyth]

I might be purchasing that seminar

[@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!

[@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

[@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

[@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.

[@Wannakatana2112]

My AfterUpdate for the combbox is not firing. I may have an earlier version of Access. did this behavior change?

[@Wannakatana2112]

ok why don't I have "find a record" in the wizard?

[@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