Listbox Source is Recordset 2

[Kib]

How can I make a listbox's source be a recordset that is created in code?
Thanks

 

[Maquis]

You could use the command:

strSQL = "Select......"
me.listboxname.rowsource = strSQL

 

[joelindquist]

This info has helped me as well. For some reason, however. If I use a variable to hold the SQL, it will not work. If I define the SQL directly in the second line, it works fine.
ie
strSQL = "Select......"
me.listboxname.rowsource = strSQL
Doesn't work

but
me.listboxname.rowsource = "Select......"
Does Work

 

[Rick39]

Try

Dim strSQL as string
strSQL = "Select......"
me.listboxname.rowsource = strSQL

 

[Francescina]

Alternatively you could use the NAME property of the (DAO) recordset. This technique is very useful because it allows you to use recordsets as recordsources for forms and reports as well!