List Box And Recordsets

[chrisperkins]

How can I assign the contents of a recordset to the row source of a list box.

I hoped that it would be as simple as :-

set mylistbox.rowsource = rst

where rst is a recordset containing approx 2000 records.

If I have to use the additem method (assuming that it is not this easy) how do I add muliple columns to the listbox?

Thanks for any support.

Chris

 

[JeremyNYC]

Chris,

How do you define the recordset? Get the sql statement that's used to build the recorset and put that into the list box. If it's a recordsetclone of a form, you can just grab the recordsource of the form. If you set it in code, with a sql statement, just use that sql statement.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.