I have a simple query attached to my combobox and bound to hidden column 1. this query retrieve around 22,000 sorted records. when I type a name it search and retrieve the record then display it on my form.
Consider I have the data below:
ID first name:
--- -------
1 bob
2 jerry
3 sam
4 terry
5 willy
6 william
the problem is when I type wi usually it display the first name that start with wi in this case "willy", my problem is it does not display it even willy is exist; however; if I type willy it retrieve the records and display all information for that name.
any ideas why sometime does not display the name in my combobox list eventhough it exist?
Thanks in Advance.
Consider I have the data below:
ID first name:
--- -------
1 bob
2 jerry
3 sam
4 terry
5 willy
6 william
the problem is when I type wi usually it display the first name that start with wi in this case "willy", my problem is it does not display it even willy is exist; however; if I type willy it retrieve the records and display all information for that name.
any ideas why sometime does not display the name in my combobox list eventhough it exist?
Thanks in Advance.