Report opens behind Form (1 Viewer)

TheSearcher

Registered User.
Local time
Today, 10:43
Joined
Jul 21, 2011
Messages
304
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

AWF VIP
Local time
Today, 14:43
Joined
May 23, 2011
Messages
4,717
To open the report, try:

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

TheSearcher

Registered User.
Local time
Today, 10:43
Joined
Jul 21, 2011
Messages
304
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?
 

Users who are viewing this thread

Top Bottom