Listbox doesn't populate all the records
I have a listbox which doesn't show all the records when there are more than about 40 records in the query result set. The query is a simple select query with two parameters. The lisbox works fine with 5 to 20 records but when it gets to 40 rows, the users do not see all of them. The list is updated by selecting records in the listbox and clicking a button which runs an update query. As a result these rows are removed from the listbox and the rows which were not showing suddenly show up! It seems like the listbox is working well but with some limitations. I have also run the query which is used for the recordsource of the listbox independently in datasheet view and all the records come up. The problem seems to be only when I try to show all the records in the listbox.
Can anyone help me with this problem or has anyone encountered such problems with listboxes?
Please note that the size of the mdb is only 7MB which I suppose that Access Jet engine can handle quiet well.
|
