Hello everyone,
I have a listbox on a form that should show all 175 records (and growing) from a table. When I load the form the listbox hardly ever shows all of the records, eg- it usually shows between 40 and 50 records. If I close the form and re-open it, I get varying numbers of records listed. I've tried adding .requery on the load event of the form, but this doesn't work.
Any ideas?
Keith
I have a listbox on a form that should show all 175 records (and growing) from a table. When I load the form the listbox hardly ever shows all of the records, eg- it usually shows between 40 and 50 records. If I close the form and re-open it, I get varying numbers of records listed. I've tried adding .requery on the load event of the form, but this doesn't work.
Any ideas?
Keith