Sean_OL
07-13-2005, 08:44 AM
I have built a form that allows a user to search a data sheet, and display the results in a listbox, however I am having a bit of trouble getting the results to display in the best way.
The results from the search a poplulated into an array which I then can populate the listbox with by using:
lstResults.list = arrSites.
However the array has empty rows at the end, so the list box is populated with empty data after the first few records.
I have tried to use the .Additem method instead, but I do not know how to use this for a multi column listbox (Site Name, Site ID, State etc.)
Should I just be happy I have the results showing, and ignore the empty rows, or is there some other way to populate the listing?
Sean
The results from the search a poplulated into an array which I then can populate the listbox with by using:
lstResults.list = arrSites.
However the array has empty rows at the end, so the list box is populated with empty data after the first few records.
I have tried to use the .Additem method instead, but I do not know how to use this for a multi column listbox (Site Name, Site ID, State etc.)
Should I just be happy I have the results showing, and ignore the empty rows, or is there some other way to populate the listing?
Sean