D
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.
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.