I am working in Access 97 and have problem with combobox.
The combo box record source is a query, retrieving few thousands records.
For some reason, the combobox does not show all record as in the query. Some times it just limits a number of line in the list row property. It means I click the combo box, and it show only 10 rows, which is the value I put in List row property.
I try to unload - load the form, but problem still occurs.
It is very strange, that when I scroll through the combobox, the number of records showed is limited for few pages. Keying the letter of last records some times works, and sometime does not. If it works, then the quantity of records increases and I can reach to the last record.
Anybody can have the same problem and share experience ?
I have not ever had or heard of such a random problem, however, if you can make a Copy of your database and input dummy data and Post here I would be glad to look at it and see if I can figure out and fix it for you.