bring to front the report

[smayshar]

My reports have ToolBar, when I open a report from a modal form it hides behind the form.
I tried to make the report popup, then it came to front but lost the tollBar.
How can I bring it to front without losing the ToolBar ?

 

[RoyVidar]

The usual way, I think, is to hide the modal form when the report opens.

For instance in the button command where you open the report, add a:

[tt]Me.Visible=False[/tt]

Then in the on close event of the report, try adding a:

[tt]Forms!frmMyPopUp.Visible=True[/tt]

I usually also test using an isloaded function, perhaps pulled from the Northwind sample database, or per Rohdems faq faq181-320 to be on the safe side;-)

Roy-Vidar

 

[smayshar]

Thenks, the broblem is that this report can be opened from some different forms, sometimes there is more then one form open

 

[RoyVidar]

Then try using the openargs of the .openreport method to send the report name, for instance:

[tt]docmd.openreport "somereport",acpreview,,,,me.name[/tt]

then in the on close of the report:

[tt]forms(me.openags).visible=true[/tt]

Roy-Vidar

 

[smayshar]

because there is more then one form open, it makes it too complex, isn't there a simple way to bring the report to front
Thanks for the help.
mayshar