Bring Report Window to Front

  • Thread starter Thread starter Barry Skidmore
  • Start date Start date
B

Barry Skidmore

Because of the way in which I am opening a report, it is displayed
behind a form window. Using Visual Basic or a macro, how can I bring
this report window "to the front", based on its name?

Thanks,
Barry
 
You can give focus to a report with:
DoCmd.SelectObject acReport, "Report1"

If your form is a popup, it may still float over the report.

If the form is opened in dialog mode, it will also remain in front of the
report unless you set its Visible property to No, or open the report in
dialog mode also (available in Access 2002 / 2003 only).
 
Back
Top