Display opened report instead of the popup form.

[lookE]

If I have a command button on a popup form that opens a report, how can I make the report display on top of the popup form?

Thank you.

 

[EnidtheDog]

Try this:

You will need a module with the following code:

Function IsReportLoaded(strName As String)
IsReportLoaded = (SysCmd(SYSCMD_GETOBJECTSTATE, A_REPORT, strName) > 0)
End Function

Then add this code to your Print Preview button on the popup form:

Forms![frmPopup].Visible = False
DoCmd.OpenReport "rptMyReport", acViewPreview
While IsReportLoaded("rptMyReport&quot
DoEvents
Wend
Forms![frmPopup].Visible = True