Display Report in Front of Forms

[JSaumya]

Hi, All,

I see several people have already had this or similar problems -most recently IanT on March 3, but I haven't found a solution that works for me.

I'm running Access 2000. I have a Switchboard from which the user can open a pop-up dialogue box.
From the dialogue box, a report opens.

When the report opens, it minimises automatically.

My Switchboard is not modal. My popup IS modal.

In my popup code, I have:
'Run the query, open the report, hide the form
DoCmd.OpenReport "rptParamTest", acViewPreview
frm.Visible = False

In my report code, I have:
Private Sub Report_OnOpen()
Dim frm As Form_Switchboard
frm.Visible = False
End Sub


What happens:
When I run the report, the popup disappears, as I want it to. But the report is minimised and the Switchboard remains in front.

Any ideas on what I'm doing wrong here?

Thanks very much!