How to show recordset in datasheet?

[rick]

I have brainfreeze!

After creating a recordset by set x = dbs.openrecordset(strSQL) and doing
all the great With x commands I would like to see the recordset in datasheet
view.

How do I do that??

Thanks.

rick

 

[Rick Brandt]

I have brainfreeze!

After creating a recordset by set x = dbs.openrecordset(strSQL) and doing all
the great With x commands I would like to see the recordset in datasheet view.

How do I do that??

As far as I know you can't. You need a table, form, or saved querydef in order
to open a datasheet on the screen. A Recordset (by itself) has no display
method.