ADP Reports

[Guest]

I hope someone can help me with this. I've got a bunch of reports created in
an ADP. I have a custom toolbar on my application interface (still using the
same ADP) which runs the reports. Some of the reports are directly executed
from the toolbar, but others are executed from a form which allows the user
to narrow down a criteria of the report. All reports that are run from the
criteria form are executed and then placed behind the interface form. Why?
The reports executed directly from the interface toolbar are given focus. Why
do all other reports automatically lose their focus?

The only thing I can think of that may be causing this is that on the
interface form I have a Maximize clause when the form gets focus.

TIA,
Eric

 

[Arvin Meyer]

Is your dialog form set as a popup? That would keep it on top. If you can't
do it any other way, set the form's visible proprty to False at the end of
the code run, and visible to True when the report closes. Simple line of
code:

Me.Visible = False

and:

Forms!YourFormName.Visible = True
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks Arvin,

It's not a clean fix... but it will definitely do. Do you have any idea why
it would be doing this though?