Reports and hidden interface

[isladogs]

NOTE: I sent this reply without seeing your comments in post #15



Rather than wait for your reply, I had a look at it anyway.
As you mentioned, the form locked up completely after the report was closed and I had to use task manager to recover.

I've got it working with various code changes all of which I've documented. Some important points
1. ALWAYS use the line Option Explicit in each code module
2. I've removed the popup property for the report. It isn't needed & was preventing the print preview ribbon being displayed
3. The form MUST stay as popup otherwise it would be hidden along with the application interface. That means it MUST be closed or it will show on top of the report.
In any case its not needed whilst the report is opened. Just reopen it when closing the report
4. Modal property wasn't needed for form or report with this example. However it works whether or not modal property is set. I've left it on.

Hope that helps

[Lhoj]

Ok, it's official, I don't get Access and VB. So, I've checked your version, seen that the form remains as it was in mine (modal and popup) and the only instruction when it loads is the HideAppWindow. Well, mine is showing the form, yours for some reason isn't. Everything appears hidden and clicking on the taskbar or alt-tabbing doesn't bring it back (I have to kill the process).

Anyway, as I said I've found kind of a workaround for keeping the form open and bringing the report to the front so I'll stick to that for the time being. If I have some time in the near future to dump on this project I'll try to change the workflow of the whole DB to keep a single item open at any time.

[isladogs]

No. Its not you.
There was a problem with the file I uploaded. Sorry!

I removed the form modal status temporarily then reinstated it.
It now works...at least for me
No code changes made.
Try the new version and let me know