Show new recordset on screen 1

[mike777]

Asking a lot of questions tonight. Thank you for your patience.
I've created a recordset,

Set rst=db.OpenRecordset(sql)

How do I get to show on the screen like a table or a query? Do I have to create a table from the recordset, then open the table, then delete the table when done viewing (unless, of course, I want to keep it)?
Thanks again for your help.
michael.kemp@gs.com

 

[RickSpr]

Is your SQL statement built by code? (If not, just create a query from it and open that.)

If your SQL is dynamically built, it would be better to built a QueryDef object and append it to the QueryDefs collection, then open it from code (and keep or delete it when done viewing). That would be faster and take less space, since you're not copying all the data into a table. Rick Sprague