View Full Version : preview report problem


extreme
01-15-2008, 01:09 PM
Please can someone help I have a label and I need to view a report I have put this code in but the report dont show in front of the db it opens behind the db

Any Suggestions

Private Sub Label17_Click()
On Error GoTo Err_Label17_Click

Dim stDocName As String

stDocName = "SurveyPriorityAlgo"
DoCmd.OpenReport stDocName, acPreview

Exit_Label17_Click:
Exit Sub

Err_Label17_Click:
MsgBox Err.Description
Resume Exit_Label17_Click

End Sub


Thanks

pbaldy
01-15-2008, 01:17 PM
Generally this means the form you're opening the report from has been opened with Popup and/or Modal set to Yes, which will keep it on top.

extreme
01-15-2008, 01:38 PM
Generally this means the form you're opening the report from has been opened with Popup and/or Modal set to Yes, which will keep it on top.

Changed that and works a treat thanks for the quick response