ListBox and Recordsets

[dave h]

Hi,

I've been using myListBox.rowsource = mySQL and this works well. Now I'd
like to assign a recordset to the listbox instead.

I've tried "myListBox.recordset = myRS " and " Set myListBoxSet.recordset =
myRS". The first version gives a runtime error and the second version does
not produce any results. I can see by using "debug.print" that the RS has
valid values.

What am I doing wrong? Thanks.

 

[dave h]

I posted this to the wrong list - sorry, but any help appreciated. thanks