Report Focus

  • Thread starter Thread starter Martin Williams
  • Start date Start date
M

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
 
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
Click to expand...

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"
 
Back
Top