Populate list box with recordset?

[utc13]

I have a list box that I want to populate using data from an ADO recordset that is currently open in memory. How do I go about doing this? I am familiar with using tables, queries, and even SQL statements to populate, but I've never used a recordset. Please help!

 

[buckfast]

Heres some code that fills a list box with queries that a user has made. I use DAO but I think ADO is pretty similar. Make sure you set the row source type to Table/Query
Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset

strSQL = "SELECT QueryID, QueryName FROM tblQuery WHERE UserName = '" & gTheUsersName & "'"

List1.RowSource = strSQL

cheers,
Ewen.