[AccessD] Turn a recordset into an actual table

[Bill Benson]

Could a datasheet subform whose recordsource is determined at runtime be
just as useful, put on a parent form?

Personally I don’t like creating and opening tables the database doesn’t
require going forward.

On Mon, Oct 18, 2021 at 12:33 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Thanks guys.
>
> A.
>
> On Mon, Oct 18, 2021 at 10:32 AM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
> > I would use a make table query that is the same as the query you use to
> > open the recordset. Just don't forget to clean up after yourself - delete
> > the table when done.  Alternatively you can put the recordset records
> into
> > a table with an append query - again, delete all records in the target
> > table before the append to insure thatr you're only looking at the
> records
> > from the recordset.
> >
> > HTH
> >
> > r
> >
> > On Mon, Oct 18, 2021 at 3:49 AM Arthur Fuller <fuller.artful at gmail.com>
> > wrote:
> >
> > > Is there a way to turn a recordset into a table? I hate not being able
> to
> > > browse the RS and see what it contains.
> > >
> > > --
> > > Arthur
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>