Access 2000 Reports

[Ray Combs]

How can you print a filtered database to an existing
report? I have created the database and I have created the
report, but I now want to print only a filtered portion of
the data base to that existing report layout. I can see
how to create a "New Object" Report from the filtered data
base, but I would like to use the existing report rather
than creating a new one. Is there a way to open the report
and have a drop down filter there on the a field of the
data base? Or how can I copy the existing report in total
to the "New Object" Report?

 

[Duane Hookom]

First, a database is the MDB file with all of its forms, reports, tables,
queries,...
Your report can/should be based on a query. Queries can have criteria that
limits the records included in the report.
Another option is to use a Where clause in the DoCmd.OpenReport method. Most
of this code is written by the command button wizard. You can add your own
Where clause.