Report opens behind Form

[TheSearcher]

I have a form (Popup = Yes, Modal = No).
I have a command button on the form that opens a report.
When the report opens - it opens behind the form. I can't close the form before opening the report because the report is dependent on a value of a field in the form (Honestly, I wouldn't want to close the form anyway). How do I get the report to open in front of the form?

 

[bob fitz]

To open the report, try:

DoCmd.OpenReport "NameOfYourReport", acViewReport, "", "", acDialog

 

[TheSearcher]

Thanks Bob! That worked! It opens on the left of the screen though. Is there any way I can have it be in the center of the screen?

 

[bob fitz]

Set the reports "Auto Center" property to Yes.

 

[TheSearcher]

Thank you so much!!!

 

[bob fitz]

Thank you so much!!!

You're welcome. Always glad to help if I can.