Populate listbox with adodb rowSource

[drag1c]

Hi,

is it possible to populate listbox over RowSource, via ADODB connection?

If possible, how to do it?

For example, this doesn't work:

lstOpenProcesses.RowSource = strSQL 'strSQL is SQL ADODB query

 

[RoryA]

No, it is not. You have to open a recordset then populate the control using something like:

lstOpenProcesses.Column = rs.getrows