Summary/Detail Report issue

[gecatoni]

Hello everyone,
I am new to this forum but have been using Access for sometime now. I am no
expert by any stretch of the imagination. My question is - i have a form
(now) that
filters a report. What i want to do is offer the user the ability to print
a report (summary or detail with different formats) based on the filter
result. I apologize if this sounds confusing. Thanks in advance for your
help.

 

[Steve Schapel]

Gecatoni,

Could you please give some specific details, with examples, regarding
how this would work in practice?

 

[gecatoni]

Hi Steve I apologize for the late response.

I have a filter on my form based on Buyers. What i want to happens is this,
base on the results of the filter I want the user to have the option of
printing "summary" or "details".
The reports are formatted differently -- if it is a concern.

thanks Steve for your help.

 

[Steve Schapel]

Gecatoni,

I guess the concept here would be that the reports both need to be based
on a query - not sure, without knowing more information, whether they
would both be based onthe same query, or they would each need their own
record source query constructed. Either way, the reports need to use
the same criteria that the formn uses for its filter process. There are
generally two approches to this. One is to include the applicable
criteria in the query that the report is based on. The other is to use
the WherCondition argument of the OpenReport method/action which is used
to trigger the printing of the report.

Sorry I can't be more specific - a generalised answer to a generalised
question I suppose.