Using Access 2003,I have a module which opens a report in Design Mode. To stop the report displaying to the user, I have the following line:

DoCmd.OpenReport strReportName, acViewDesign, , , acHidden

However, when the following piece of code is run, the report still opens up in Design Mode to the end-user :

    DoCmd.OpenReport strReportName, acViewDesign, , , acHidden

    rs.MoveFirst
    Do Until rs.EOF
        Reports!strReportName.Filter = "Criteria = " & rs!Crit
        DoCmd.OutputTo acOutputReport, strReportName, A_FORMATRTF, _
         strFileLocation & rs!Crit & ".rtf"
        rs.MoveNext
    Loop

    rs.Close
    DoCmd.Close acReport, strReportName

Question: what need's to be changed with the above code to ensure the
report doesn't open up in design mode to the end-user?

Thank you

You're setting the criteria AFTER you open the report. Therefore, Access is giving the report the focus in order to do that, hence your problem.

My recommendation is that you set the criteria BEFORE the report opens (as a field on a form) and then use the OutputTo command or the OpenReport action ALONG WITH the criteria.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division