Solved Dropdown list

[Springblossom]

@arnelgp : Hi Arne, I have a problem with the dropdown list you helped me with before.
When I write a name, it shows the results, but when I continue to write the last name or middle name everything disappears. In order to try again, deleting the last name does not help, I have to delete everything in the fiels to show some results again.
ex: I write John then all names with john is shown in the dropdown list. When I write John West, the dropdown is empty, although there are two john west on the list.
Could you please help with the problem?

 

[arnelgp]

i made some sample data in employees and project table (so delete them and add the Linked table again).
on the Keypress Event, i did noticed that character space (ascii 32) is not being taken.
test if it will work now.

 

[Springblossom]

Thank you very much. I will try it now.

 

[arnelgp]

the one i touched is the class autocompletecombo, so you need to replace your whole class with
the one i upload.

 

[Springblossom]

sure, thank you for the guidance.

 

[Springblossom]

i made some sample data in employees and project table (so delete them and add the Linked table again).
on the Keypress Event, i did noticed that character space (ascii 32) is not being taken.
test if it will work now.

It works perfectly. Thank you Arne.