passing a recordset

Please forgive me if this is similar to the question asked on 6/2/2005, but I
do not quite understand it....

I am use to using VB6 with crystal reports. What I need am trying to do is
use VBA like VB 6 to grab data from a couple of tables and put that info in a
local recordset. In crystal reports, you can specify a recordset as a
datasource. A datasource is a property in crystal that you can use to
specify a datasource which can also be tables, etc. In VB 6 I create a local
recordset with the shape data provider building my own local table. I may
assume, I can also do this using disconnected recordset in ADO to create a
local table structure and then populate it with a local recordset. I used
RDO in VB 6, so this was not possible, hence the use of the OLE DB data shape
provider to build a local table structure and then a local recordset. After
this long winded question... :

Can I use a similar method to pass a recordset from a form to a report as a
record source. In looking at the data properties in a report, it only lets
you select tables for the record source property. Any help is appreciated....

Thanks,
Jason

Made a little mistake above. I see that the recordsource property allows you
to also select a query. Problem is I don't think I can use this method as I
am creating a LOCAL table in memory and creating a recordset based on the
local table in memory. Therefore I need to pass the recordset. I am not
storing the table in the database - only in memory. Is this possible....?

"85ascMcLaren" wrote:

Please forgive me if this is similar to the question asked on 6/2/2005, but I
do not quite understand it....

I am use to using VB6 with crystal reports. What I need am trying to do is
use VBA like VB 6 to grab data from a couple of tables and put that info in a
local recordset. In crystal reports, you can specify a recordset as a
datasource. A datasource is a property in crystal that you can use to
specify a datasource which can also be tables, etc. In VB 6 I create a local
recordset with the shape data provider building my own local table. I may
assume, I can also do this using disconnected recordset in ADO to create a
local table structure and then populate it with a local recordset. I used
RDO in VB 6, so this was not possible, hence the use of the OLE DB data shape
provider to build a local table structure and then a local recordset. After
this long winded question... :

Can I use a similar method to pass a recordset from a form to a report as a
record source. In looking at the data properties in a report, it only lets
you select tables for the record source property. Any help is appreciated....

Thanks,
Jason