[AccessD] Turn a recordset into an actual table

[Rocky Smolin]

Assuming the parent form doesn't already have its own record source, it
would seem to be simpler design.

r

On Mon, Oct 25, 2021 at 5:06 PM Bill Benson <bensonforums at gmail.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>