how to keep a report window ...

[mchd]

.... in fron of all ther windowd in MS Access 2000 ? when i try to preview a
report from a dialog box , the report windows dispalys in back of the dialog
box

any solution? thanks for any help

 

[fredg]

... in fron of all ther windowd in MS Access 2000 ? when i try to preview a
report from a dialog box , the report windows dispalys in back of the dialog
box

any solution? thanks for any help

Simplest way is to hide the dialog box if you open the report from
that form.

DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False

If the report itself has opened the form, then just make the form not
visible:
Me.Visible = False

Code the Report Close event to make the form visible again:

forms!FormName.Visible = True

or to close the form:
DoCmd.Close acForm, "FormName"