DoCmd.OutputTo recordset?

[sabavno]

hi,

I was wondering if I could output recordset rather than table?

DoCmd.OutputTo acOutputTable, "Groups", acFormatXLS

Could I possibly have recordset name instead of the table name in this code line?

Thanks.

 

[LonnieJohnson]

Thats a good one. My first guess would be to create a Query Def from the recordset, output the query, then delete the query.

Just a thought... lonniejohnson@prodev.com
ProDev, MS Access Applications B-)

May God blow your mind with His Glory in 2003.