Displaying a Report Properly from a form When Pop-Up is enabled

[thlionhrt]

Hi:<br>
<br>
As the subject line says, I am having problems Displaying a Report Properly from a form When Pop-Up is enabled. I have this done in an application with it Menu driven through a series of forms and display database window set to No. Borders are set to no and Max Min and exit buttons set to none as well as scroll bars are turned off.<br>
<br>
The problem being is that it will allow me to pull up the forms as they come up with a Maximize Macro set for on Open and on Activate. With that in mind it runs my report in the background and will not disply it on the front portion. You actually have to go into form design to clear everything.<br>
<br>
What I would like to do is once the report (Print Preview) is activiated, I need to bring this to the front without displaying the back end of the application.<br>
<br>
Cheers<br>
<br>
Scotty<br>
aka ThLionHrt

 

[WP]

I.m not sure what you are going on about but, if you are trying to display your report and it comes behing the pop-up form then what you want to do is hide the pop-up while the report is open.<br>
<br>
<br>
syntax is:<br>
<br>
Private Sub Report_Open(Cancel As Integer)<br>
Forms!formname.Visible = False<br>
End Sub<br>
<br>
Private Sub Report_Close(Cancel As Integer)<br>
Forms!formname.Visible = True<br>
<br>
End Sub<br>
<br>
<br>
WP<br>
<br>
<p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[WP]

I.m not sure what you are going on about but, if you are trying to display your report and it comes behing the pop-up form then what you want to do is hide the pop-up while the report is open.<br>
<br>
<br>
syntax is:<br>
<br>
Private Sub Report_Open(Cancel As Integer)<br>
Forms!formname.Visible = False<br>
End Sub<br>
<br>
Private Sub Report_Close()<br>
Forms!formname.Visible = True<br>
<br>
End Sub<br>
<br>
<br>
WP<br>
<br>
<p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>