Report Focus

[Martin Williams]

Hello,

I have a button on a form which when clicked, opens a
report. Auto Resize, Auto Center, Pop Up and Modal are
all set to YES on the form. When the report is opened,
it is behind the form. How can I get the report to open
in front of the form?

Note: I tried setting the Windowmode in the Open Report
to Dialog in the Open Report method, however in that mode
the toolbar is not accessible.

Thanks,

Martin

 

[fredg]

Hello,

I have a button on a form which when clicked, opens a
report. Auto Resize, Auto Center, Pop Up and Modal are
all set to YES on the form. When the report is opened,
it is behind the form. How can I get the report to open
in front of the form?

Note: I tried setting the Windowmode in the Open Report
to Dialog in the Open Report method, however in that mode
the toolbar is not accessible.

Thanks,

Martin

Code the form's command button to make the form not visible when the
report opens:
DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False

Code the report's close event to either make the form visible again:
forms!FormName.Visible = True
or close the form:
DoCmd.Close acForm, "FormName"