Viewing a Report

[Robert2150]

I have a database designed and I operate it from a Main Form. I have put a button on the Main form to View a Report. the report does open, but it opens behind the Main Form. I want the Report Preview to open in front of the Main Form, any suggestions? Thank You.

[pbaldy]

Sounds like popup and modal are true for the form. Change those, or hide the form and make it visible again in the close event of the report.

[Robert2150]

Thanks Paul, Yes the Main Form is set with PopUp True, this is necessary for operation of the program when logging in, etc. Any suggestions on hiding the form and making it visible again with code?

[pbaldy]

Me.Visible = False

Forms!FormName.Visible = True