How to show recordset in datasheet?

R

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
 
R

Rick Brandt

rick said:
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??
Click to expand...

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.
 
Top