Help with Report viewing and printing

[bscottj48]

I have a small db. I have set it up to be very user friendly (I hope). When a user clicks on the icon to open the db, the app window auto hides and the user sees just the start form. On all other subsequent forms, the app window stays hidden. The user can go from form to form and back and still not "see" the app window. HOWEVER, when the user clicks the button to print the form (I have code for it to open in Print Preview in order for them to choose their own print settings), the report is not showing in front of the form. The user has to click on the Access Prgm icon and the report shows then. i would like the report to come to the front (in front of the form).



This is the code I am using for the report.

Option Compare Database
Option Explicit


Private Sub Report_Load()


'Removing all access information code
'Global Const SW_HIDE = 0
'Global Const SW_SHOWNORMAL = 1
'Global Const SW_SHOWMINIMIZED = 2
'Global Const SW_SHOWMAXIMIZED = 3
'User one of the following below:
'Call Module2.fSetAccessWindow(0)
'Call Module2.fSetAccessWindow(1)
Call Module2.fSetAccessWindow(2)
'Call Module2.fSetAccessWindow(3)
End Sub


Private Sub Report_Open(Cancel As Integer)
Forms![Issue_Details].Visible = False
DoCmd.SelectObject acTable, , True
' DoCmd.RunCommand acCmdWindowHide
Reports![rptIssues].Visible = True
End Sub



Not smart enough to figure this out. Please help.

[June7]

Are forms set as Popup?

[bscottj48]

I'm an idiot. They were set to "yes" on PopUp and Modal. I did the same with the Report, and it works great. Thanks, for your help.