Displaying a DAO recordset

  • Thread starter Thread starter Mike Turner
  • Start date Start date
M

Mike Turner

How do you display a (DAO 3.6) recordset? (The recordset
is a filtered version of a table,created from a
switchboard form and I would like it to be displayed in
the same in the same manner as the underlying table).

I had thought of creating an empty version of the
underlying table (using design view) then populating this
with the filtered recordset at run-time but this seems
messy.

Many thanks for any help

Mike Turner
 
Alsion,
Thanks very much.Is there a datagrid that comes with
Access (2002)? I am wondering what reference I need to
set up?

Thanks

Mike
 
Hi,
Use a query to select the sub-set of records from your table
then use that as the Row Source for a form in datasheet view.
 
Thanks Dan,much obliged

-----Original Message-----
Hi,
Use a query to select the sub-set of records from your table
then use that as the Row Source for a form in datasheet view.

--
HTH
Dan Artuso, Access MVP





.
Click to expand...
 
Back
Top