multiple instances of reports

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 ?
 
A

Allen Browne

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.
 
Top