report bring to front

[Guest]

i have a few forms that are set to pop-up and modal, one of these forms calls
a report, it is necessary for these forms to be pop up for security purposes,
is there anyway that when opening a report from a pop up form, the report is
brough to the front? as in a report with a pop up property

 

[Allen Browne]

You can open the report in dialog mode only if you are using Access 2002 or
later.

If you opening it programmatically, use:
DoCmd.OpenReport "Report1", acViewPreview, , , acDialog

 

[Guest]

thanks but is there no way of doing it in access 2000?

 

[Allen Browne]

That's correct.

 

[fredg]

i have a few forms that are set to pop-up and modal, one of these forms calls
a report, it is necessary for these forms to be pop up for security purposes,
is there anyway that when opening a report from a pop up form, the report is
brough to the front? as in a report with a pop up property

Easiest method to view the report is to simply set the pop-up form's
Visible property to False when the report is opened, then re-set it to
True when the report closed.

Code the pop-up form's Command button click event:
DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = false

Code the Report's Close event:
forms!PopUpFormName!Visible = true

'(or close the form if it's no longer needed)
DoCmd.Close acForm, "PopUpFormName"