Report is Opening Behind Switchboard

[Jkittle]

I have created two reports that I open after a shift code is selected from a combo box on a form. I want the selection form to close after opening the report so I wrote in a do command close in the command button but now the reports don't open properly.

Anyone have any suggestions?

Thanks,

Jerry

 

[RuralGuy]

Try adding ,acDialog to each OpenReport command.

 

[Jkittle]

Where do you should the acDialog go? I tried a couple time and I get an error.

Everything works, its just the silly report opens behind the switchboard and then I have to minimize the switchboard to get the report. The people on the floor think the report didn't run.


Private Sub Open_Shift_Scrap_Report_Click()
On Error GoTo Err_Open_Shift_Scrap_Report_Click

Dim stDocName As String

stDocName = "R-Machine_Scrap_By_Shift"
DoCmd.OpenReport stDocName, acPreview, , "[ShiftCode]=" & Me.txtshiftcode
DoCmd.Close acForm, "F-Select_Shift_Code", acSaveNo

Exit_Open_Shift_Scrap_Report_Click:
Exit Sub

Err_Open_Shift_Scrap_Report_Click:
MsgBox err.Description
Resume Exit_Open_Shift_Scrap_Report_Click

End Sub

 

[extreme]

Here you are all done

 

[Jkittle]

Extrem,

How did you fix it? I didn't any difference in the code.

 

[Jkittle]

Okay I see where the report properties was changed to a "pop up" .

Thank you! I can't believe it was that simple. Thank you again

 

[extreme]

Okay I see where the report properties was changed to a "pop up" .

Thank you! I can't believe it was that simple. Thank you again

Thats ok I had the same problem