Setting active report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some vba code that opens a progess bar form and will then proceed to
open a report in print preview mode. Once the report is displayed, the code
then closes the progress bar form. At this point the report is no longer the
active window and is sitting behind additional open forms. How do I set the
report to be the active window again and be displayed in front of other
forms?

Here is sample of code:
...
Call frm.UpdateProgress("Formating data", 9)
DoCmd.OpenReport "rptRepInventory", acViewPreview
Call frm.UpdateProgress("Formating data", 10)
DoCmd.Close acForm, "frmProgressBar"
 
franky said:
I have some vba code that opens a progess bar form and will then proceed to
open a report in print preview mode. Once the report is displayed, the code
then closes the progress bar form. At this point the report is no longer the
active window and is sitting behind additional open forms. How do I set the
report to be the active window again and be displayed in front of other
forms?

Here is sample of code:
...
Call frm.UpdateProgress("Formating data", 9)
DoCmd.OpenReport "rptRepInventory", acViewPreview
Call frm.UpdateProgress("Formating data", 10)
DoCmd.Close acForm, "frmProgressBar"
Click to expand...


Try using:
DoCmd.SelectObject acReport, "rptRepInventory", False
 
Back
Top