[ComboBox] Search as u type

[LukeSky]

Hi, I have created one example for combobox but it behavior is strange. I uploaded video that is better than 1000 words.

I upload mdb file for you analyze and debug error. Thanks in advance.

https://youtu.be/t5UaavkN4PU

 

[isladogs]

I've looked at your example db and tried to view your you tube video but it doesn't work for me.
Please explain what the issues are and upload a zipped copy of your video here if it's not too large

 

[LukeSky]

I already notice my error, this statement "Me.ccoEmisor.RowSource = "qryEmisor_Todos"" work incorrectly in event gotfocus but fine in lostfocus.

Sorry for disturbing and my english. Regards.

EDIT: I forgot to change nivel privacity in youtube, you should can see it now

EDIT2: I did upload example right.

 

[jdraw]

LukeSky,

Suggest you write your response in your native language, then use Google translate to get English. I have responded to posters in French, Polish, Hungarian.... using this facility.


Estoy adivinando español:::
Te sugiero que escribas tu respuesta en tu idioma nativo y luego uses Google Translate para obtener el inglés. He respondido a los carteles en francés, polaco, húngaro ... utilizando este servicio.

 

[LukeSky]

Hello again. With the exposed combobox it filters results according to the inserted text, however I have observed a strange behavior. If I insert a word that sequentially matches a record in the combobox, that object does not filter the matching records. However, if I force an incorrect script and correct it, now it shows the only match according to the text entered.

I have noticed that when inserting a space between two text strings, the change event is not triggered, and I think it might be altering the result of the SQL statement. Also if I enter a character '?' instead of a space between 2 words, then I get what I'm looking for with the behavior of the combobox.

I have uploaded a sample video and database. Thanks in advance.

https://youtu.be/XnVwqJf6pCM