• I think it varies. Both will work, assigning the recordset to the listbox is definitely easy though may not be powerful/flexible enough. Figure out how you want to handle the binding, then do the caching. Caching is a separate and easily added feature...well, more or less!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/