Filling a listbox
Hi,
I have added a multi-column ListBox to a user form and need to fill it with
data using VBA/ADO
the data is retrieved into a recordset from SQL Server using this statement:
rst.open "select Id, Name, Address1 from Customers where name like
'abc%'", oconn
I am looking for something like lstCustomers.rowsource = rst, which does not
work here
Thanks in advance for your suggestions.
Regards
Habib
|