Multi-column Listbox - Dynamic range - over 4,000 rows of data

All,

I am trying to get a listbox to show 10 columns of data based on a few criteria. In my database, I currently have 4k rows of data that is comprised of companies, invoices, and payments. What I am trying to do with the listbox is show all of the invoices for a particular company. Later on, I would like to show only the outstanding invoices in the listbox but for now I want to attempt to just get some data in my listbox to appear. So far this is what I have:

Please Login or Register  to view this content.

When I run this code, the listbox shows blanks for half a page, then one line of invoice information, and then the rest of the page is filled with blanks.

Can someone please help?

Thank you in advance.

J

What's the problem?

You aren't using Redim Preserve which means every time you ReDim you lose all the data in the array.

Give this a try.

Please Login or Register  to view this content.

Hey Norie,

Thanks for your help but I am getting a Run-time error '438': Object doesn't support this property or method. It is highlighting

Please Login or Register  to view this content.

Do you know why this could be happening?

Thank you again.

J

Did you not notice that I switched the dimensions of the array around?

It's now 1 To 10 by 1 To xBal and needs to be that way as you can only redimension the last dimension when using Redim preserve.

So that line should be this

Please Login or Register  to view this content.