many instances of a report with different data

[Nhan]

Hi,
I have a access program, that allows users to open different instances of a
report in preview modus, each instance had own data.
How can I do this?
I can create many instance of a report with
dim rpt as report_report1
set rpt = new report_report1

but when an instance is created, the report is loaded, opened and formated
immediately.
I can't pass any parameter.

Thanks for help
Nhan

 

[Jeff Boyce]

Nhan

One approach might be to base a single report on a query, as the source.
The query could have the parameter you wish to provide as a criterion for
one of its fields.

Should you wish to provide your users with a simpler approach, create a form
on which they select the criterion/parameter, and modify your query to look
to that form for its parameter/criterion. The query's criterion would look
something like:

Forms!YourForm!YourField

 

[Nhan]

Thanks
Nhan

Nhan

One approach might be to base a single report on a query, as the source.
The query could have the parameter you wish to provide as a criterion for
one of its fields.

Should you wish to provide your users with a simpler approach, create a form
on which they select the criterion/parameter, and modify your query to look
to that form for its parameter/criterion. The query's criterion would look
something like:

Forms!YourForm!YourField

--
Good luck

Jeff Boyce
<Access MVP>

of