Report Preview is hidden behing the Form

[Joe Coulter]

Hi

Hopefully someone can help me with this, there are some solutions here that
almost fit but I cant find the one for me.

I have a Popup Form (FRM_HEAD) which contains a number of sub forms within
Tabs. One of these sub forms (FRM_REPORTS) is used to print preview various
reports, run from Command Buttons.

My problem is, that when I run a report, it always appears behind the form
(FRM_HEAD). This form is a popup form, I know that if I make the Form
(FRM_HEAD) not a popup, the Report will appear in front, however, I need the
form to be Popup.

How can I make the Report come to the Front?, or hide the Form when the
Report Appears, and then Show the Form again at the Report Form Tab when the
Report Closes?.

Any Help would be greatly appreciated.


Joe

 

[Keith Wilby]

Hi

Hopefully someone can help me with this, there are some solutions here
that
almost fit but I cant find the one for me.

I have a Popup Form (FRM_HEAD) which contains a number of sub forms within
Tabs. One of these sub forms (FRM_REPORTS) is used to print preview
various
reports, run from Command Buttons.

My problem is, that when I run a report, it always appears behind the form
(FRM_HEAD). This form is a popup form, I know that if I make the Form
(FRM_HEAD) not a popup, the Report will appear in front, however, I need
the
form to be Popup.

How can I make the Report come to the Front?, or hide the Form when the
Report Appears, and then Show the Form again at the Report Form Tab when
the
Report Closes?.

Any Help would be greatly appreciated.


Joe

Set the form's Visible property to False in the report's Open event and to
True in the report's Close event.

Keith.

 

[Beetle]

Set it's visible property to false in the event that opens
the report, then set it back to true in the report close event.

If the report(s) can be opened by another method (without
FRM_HEAD being open), then you'll want to include an
IsLoaded function in the report close event.