Use recordset to populate list control

[dhartford]

yes. It takes the entire recordset returned by your ADO connection and converts it all into a String. I'm not sure how it will interact with the listbox's columns though... it may parse the fields into different columns (in which case you will need to adjust the column number and widths for the list box's properties) or it may contain it all in a single columnn (for each record).

I tried and recordset works fine, but the data displayed in box is a row: ABCACEChubbDDDGACGAIC, instead of a list like this:

ABC
ACE
Chubb
DDD
GAC
GAIC

May be I need to save the record to a table, then bound control to it.

Thanks.