many instances of a report with different data

  • Thread starter Thread starter Nhan
  • Start date Start date
N

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
 
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
 
Thanks
Nhan

Jeff Boyce said:
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
Click to expand...
 
Back
Top