multiple instances of reports

  • Thread starter Thread starter Miranda
  • Start date Start date
M

Miranda

hi,

i posted a message yesterday (multiple form instances and a report). and i
was just wondering about something. if i have a form whcih can possibly have
muliple instances open and from those forms i want to be able to open
multiple instances of a report - can i do it in a similar way to the form
i.e. using the hwnd ?
 
Hi Miranda.

It is possible to open multiple instances of a report, but managing them is
a nightmare.

When you open them with the New keyword, you cannot use a WhereCondition
like you can with OpenReport. You therefore have to set the reports Filter
in its Open event, but Access is likely to apply the filter to the wrong
instance, even if you specify the instance unambiguously. There is a
downloadable example of this flaw in this article:
Incorrect filtering of forms and reports
at:
http://members.iinet.net.au/~allenbrowne/bug-02.html

In general, I think it's not worth the effort of trying to open and manage
multiple instances of reports.
 
Back
Top