Bind ADO Recordset (filtered) to a Listbox

[JimS]

I know I read somewhere you can do this...

I have an ADO recordset built on a highly complex and slow query. I've
filtered it and I want to assign the filtered query as the ?Control Source
?RowSource? to a listbox which will display 3 or 4 of the 10 or so fields as
a debugging tool. How do I assign this run-time only ADO recordset to the
listbox?

 

[Brendan Reynolds]

I know I read somewhere you can do this...

I have an ADO recordset built on a highly complex and slow query. I've
filtered it and I want to assign the filtered query as the ?Control Source
?RowSource? to a listbox which will display 3 or 4 of the 10 or so fields
as
a debugging tool. How do I assign this run-time only ADO recordset to the
listbox?

You need to assign the recordset to the Recordset property of the control.
Here's a link to the on-line help topic ...

http://office.microsoft.com/client/...ESS.DEV&lcid=2057&QueryID=ZBbDrM-ks0&respos=1

This isn't something that I've ever done in practice, so I can't say how
well it works.