Popup Reports

[Joe Coulter]

Hi

I have a problem that I would appreciate some assistance with.

I have a popup form (FRM_HEAD) which runs a report (RPT_WEEK_SUM) in Preview
mode from a command button.

When I run a report it appears behind the popup and cannot be seen by the
user.

I need the form to be popup, I have tried hiding the popup form when the
Report opens, but get a message "cant hide .. object has focus" how can I
open the report, set the focus to the report and then hide the popup form,
then show the form on the report closing?.

Even if I could open the Report within a form would be a great help.

Either solution would be acceptable for my application.

Thanks in anticipation


Joe

 

[Mark Andrews]

You can add acDialog as the last argument in the DoCmd.OpenReport call to
open the report on top of your dialog form. That will open it in a smaller
window but on top of the form.

Running the report the other way is possible (but I can't remember of the
top of my head what code is needed to hide or close the form so the report
can be run in normal mode).

HTH,
Mark

 

[kismert]

Looks like you've painted yourself into a corner.

Your popup form is behaving exactly as it should.
Reports can't be opened in popup mode, so if you close your form, you will
no longer be protecting what your popup form is supposed to protect.
And, you can't embed subreports in forms (although I think you can in Access
2010).

Either redesign your report as a subform, or find another approach that
eliminates the need for your popup.

-Ken