Report Opens Behind The Open Form - help needed to fix this problem

[aamer]

I have a form "DialogSupPur" with A button to open report "PurSupRpt1" when the reoprt opens it does not open in front of form instead it opens behind a form "SWITCHBOARD" whereas all other forms and reports are working fine with the similar conditions.
the following code is used to open the report.

Private Sub SupPurBtn_Click()
On Error GoTo Err_Handler

Const ReportName = "PurSupRpt1"
Const MESSAGETEXT = "No Item Selected."
Dim strCriteria As String

' build string expression to filter report

strCriteria = "[SupervisePLogin By] = """ & Me.CboSupPur & """"



If Not IsNull(Me.CboSupPur) Then
DoCmd.OpenReport ReportName, _
View:=acViewPreview, _
WhereCondition:=strCriteria

Else
MsgBox MESSAGETEXT, vbExclamation, "Invalid operation"
End If

Exit_Here:


Exit Sub

Err_Handler:
MsgBox Err.Description, vbExclamation, "Error"
Resume Exit_Here


End Sub

[isladogs]

Sounds like your form is a popup form. If that's not needed remove those property.
Otherwise several solutions possible - use whichever suits your needs best: hide your form when opening the report or make your report a popup or open it in dialog mode

[aamer]

yes its a popup form and is needed
what code should i add to the code by which when "PurSupRpt1" report opens the form "DialogSupPur" is closed.

[isladogs]

Two possible approaches
1. On the form procedure that opens the report add the line DoCmd.Close acForm, Me.Name immediately after the code to open the report
OR
2. On the Report_Open event, add the line DoCmd.Close acForm, "YourFormNameGoesHere"

You may want to reopen the form afterwards by adding suitable code to the Report_Close event.

Another method is just to hide the form rather than close it e.g. using Me.Visible =False