pass recordset to listbox.rowsource

[Crookshanks]

Hello there,

I've build a query and I passed that query to a record set, like this:

dim strSQL as string
dim rs as DAO.Recordset
strSQL = "SELECT ..... bla bla"
set rs = currentdb.openrecordset(strSQL)

I do some modifications in the record set (remove some records) and afterwards I want to display the modified record set in my listbox. What's that best way to do it? I can't just add rs to my listbox. Any help appreciated....

Kind regards,

 

[PWise]

Try

dim strSQL as string
dim rs as DAO.Recordset
strSQL = "SELECT ..... bla bla"
set rs = currentdb.openrecordset(strSQL)
....
[b][i]set mylstbox.recordset=rst[/i][/b]

 

[Crookshanks]

It works. Thanks. Did not know about the recordset property.