Open report problem

[jeff1]

I have a button on a "Pop Up" form that opens a report. I am having trouble opening the report so that it is not behind the Popup form. I prefer the form to remain a "Pop up" I would like to have the form regain focus after the report is closed. I know I have done this befor but the solution is avoiding me.
Thanks in advance for your help.

 

[RoyVidar]

Hi!

In the line before docmd.openreport...

me.visible=false

In the on close of the report, do...

forms("frmYourPopUp&quot.visible=true

NOTE - you'll probably need some code to check whether it's open first, and when the report gets focus, the user can do a lot of things;-)

Roy-Vidar

 

[ptpaton]

Jeff

Although Roy-Vidar's suggestion will work, all you should have to do is set the Pop-Up property back to no and set Modal to yes. That should solve your problem.

Good luck!

-Patrick

Nine times out of ten, the simplest solution is the best one.