Report won't show over Pop up form

[Roby]

I have a pop up form that has report button macs on it. But when I hit the
button to preview the report, the pop up form remains as the current view.
The pop up form must be closed or minimized to see the preview report. Would
anyone know how to make the report be the main view when the button is
depressed.

 

[fredg]

I have a pop up form that has report button macs on it. But when I hit the
button to preview the report, the pop up form remains as the current view.
The pop up form must be closed or minimized to see the preview report. Would
anyone know how to make the report be the main view when the button is
depressed.

Code the report button's click event something like this:

DoCmd,OpenReport "ReportName", acViewPreview
Me.Visible = false

Code the report's Close event:
Forms!PopUpFormName.Visible = True

The button will open the report and the form will be not visible.
When you close the report, the form will again be visible.

 

[Roby]

That worked perfect!!! Thank you

Code the report button's click event something like this:

DoCmd,OpenReport "ReportName", acViewPreview
Me.Visible = false

Code the report's Close event:
Forms!PopUpFormName.Visible = True

The button will open the report and the form will be not visible.
When you close the report, the form will again be visible.