How to Filter the Data in a Combo Box or List Box as you Type in Microsoft Access

[@Shadow.Dragon]

Richard, thanks for the timely video! The other day, I was working on a database and was wondering how I could filter the combo box!

[@joshuajegede8253]

Thanks so much. This was super helpful on a project I am currently handling.

[@599CD]

Glad it was helpful!

[@yawarabbas205]

Sir thanks so much you shared this code. I tried so much to find it but failed. Thanks again, sir. God bless you

[@sheikhobaba]

Thanks sir , Your all lecture are great. Love you

[@mahmoudbarrawi7092]

Thanks Richard really you are doing great job

[@nipcfo5893]

Hello I use your this combo box itext thing n my access app which has sequel server at the back end but it really slows down the entire form

[@altdel126]

Excellent👍 I was looking for the same

[@fdnyfish]

I'm receiving an 2185 error after selecting from the list

[@599CD]

Run down the troubleshooter... 599cd.com/trouble

[@thomaswesonga3868]

Enhance clarity maybe zoom for us

[@marcellomg.giovannini4119]

Good job !!!!

[@599CD]

Thanks

[@tonychaar6780]

Great one

[@SonJboy45]

Sir Richard, thank you for all our videos. This is easier than searching solutions in google and Bing Chat often gives a link to one of your videos whenever I ask for some codes. I do also want to ask if there is a way to have power query feature in ms access? Power query can get data from different sources however it is only in excel.

[@user-bj4lp3fr1o]

Great video.

[@599CD]

Thanks

[@dmenace9288]

Thanks heaps :)))

[@imstevemcqueen]

Very cool😊

[@navisalomi]

Cool. Very helpful

[@janvanantwerp6574]

YUP very cool...

[@doctorchinmoy]

Great 👍 Can u explain how can the sorting be done first those name which begins with the text typed by the user and then wherever the typed text is in within the searched name?

[@badmustunde6508]

Good day sir, I have being enjoying your tutorial recently, pls sir do you have anyone on student report sheet creation or the guide to develop one, thanks

[@KentReynolds]

Can anyone explain why it’s such a no no to have a space in a table name or field name ?

[@599CD]

I explain in detail in my Beginner 1 class. Essentially it's a pain having to remember to put [Brackets] around your fields ALL. THE. TIME. in SQL, in VBA, in query fields, pretty much everywhere. Just don't do it. :)

[@ambrandaoyoutub]

Hello Richard, thanks for your lessons, I learn a lot from them spite being on the free courses. I would like to ask you how can I join the lesson from "Microsoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo Box" (After Update event) to the "How to Filter the Data in a Combo Box or List Box as you Type in Microsoft Access" (On Change event). I try to use in the "CustomerF" made in the cascading combo lesson (Country, State and City), filtering the "CountryCombo" with "On Change event" and using "After Update event" like you mention, and when I load the form or go to other record to fill it up with data, the "CountryT" continuous with the previous filter on that table giving the impossibility to choose another value to the "CountryCombo" field. Can you give me some insight? I think that I need to put some VBA "On Change Event" to remove the filter from "CountryT" when I load the form or go to another record after update the State and City field. Thanks.

[@solution100]

HI..Richard..The combox box work fine with the mouse to go down.the items. ..Now if i press the down key it just select the one the is focus. NOt practical. How can i put the down key simple to go to the next item or the up key..

[@599CD]

599cd.com/Ask

[@mikemlazgar5700]

I tried this on a combo box on a continuous form, and as soon as I started typing all the combo boxes (for each record) blanked out. Will this not work with combo boxes on a continuous form, or is it something |I did wrong?

[@599CD]

You are correct that this technique will not work in a continuous form. There are some tricks you can play to get it to work in a continuous form and I cover something similar in the Extended Cut for this video: 599cd.com/Cascading

[@faisalashfaq542]

hi richard, big fan of your great work, please can you make a video where you can search in a search form and return the value to another form like you do in oracle forms L.O.Vs I really do need it

[@599CD]

599cd.com/FormName

[@user-ew7hy9mk7m]

Hello Sir, i need cmb list *Filter as type*

[@nutsonbikes]

Rick rocks again

[@nlt-g3v]

Unfortunately, this approach creates more problems than it solves. If you type something and after filtering you want to browse through the options suggested with the up and down arrows on the keyboard then an unpleasant surprise awaits the user. You are forced to navigate with the mouse otherwise with the first movement of the arrows all options are lost!!! Even worst if you choose one option and go to create new record then in the new record if you open the dropdown with mouse then it has only the previous one!!! So if you want to see all the options you are in a nightmare!!!

[@stevekampa3851]

Thank you for the heads up!

[@afrinsir7479]

awesome