Get Report to the front from behind of the form

[teqtaq]

I have a form, it set to pop-up when used double-clicked on .mdb
Then user pickes out values from the cmb box and pushes the button to run the Report.
Report appearing behind the Form.
How can I make it to appear in fron of the form?

Thanks

 

[genomon]

Have you tried ReportObjectName.SetFocus?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[dhookom]

Try open the report in dialog mode or set the form temporarily to invisible.

Duane
Hook'D on Access
MS Access MVP

 

[teqtaq]

Thanks to both, trying now.

 

[teqtaq]

All right, I have written before Report Opens Me.Visible=False and on Report Close Private Sub

Report_Close()
Forms!Reports.Visible = True
End Sub

Thanks and if you can advice me on error hendler if something goes wrong...thanks