>How do i populate a listbox with some records (sql query being used) from a table .
>
>Thanx for the help in advance.
You can set the listbox's RowSourceType to 3 - SQL, and write the SQL in the RowSource
or
Set RowSourceType to 0 - none, somewhere in your code Select-SQL your data into an array, then, using:
YourList.AddListItem(),
add each array line into the listbox, in a loop around the array.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
