ComboBox skip displaying some records 1

[ruru9292]

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.

 

[RoyVidar]

22 000 records in a combo - that's - much... I haven't worked with combos with so much data, but Allen Browne has, see if this link helps Combos with Tens of Thousands of Records

Roy-Vidar

 

[willir]

Access can be configured to only retrieve a set number of records in a combo or list box.

"Tools" -> "Options" -> "Edit/Find" tab
"Don't display lists where more than this number of records read"

Retrieving 22,000 records is a lot, and can generate a lot of network traffic.

An approach would be to consider having the end user type in the first three characters and then apply the filter to load the combo box.

You would have to use the OnKey event and take advantage of the RowSource property.

Richard

 

[ruru9292]

Thanks Willir. The link works great.

 

[ruru9292]

Thanks Roy-Vidar for your Link. It helps a lot.