Solved: Combo box not displaying all records

[Movian]

Hey,
I have a combo box that is pulling a list from a table through a SQL query in the row source

"SELECT ID, ICD9 FROM tblICDList ORDER BY ICD9 ASC"

There are 12,757 records in that table and acording to my research a combo box should be able to display 65,535 records (http://www.applecore99.com/frm/frm048.asp)

HOWEVER when i drop down the list box and or soft search for some items later in the list (typing directly in the combo box) I discover it is only display around 10,084 records....

Does anyone know why it may be doing this and how I might fix it?

[Movian]

Looks like access Options->Advanced->Advanced-> Default Max Records

And changing current database->Filter options

both to higher numbers has helped correct this problem.

The clients will be using a soft search by entering the first few letters of the items in the list so the large number of items shouldn't be a problem.