I have the following code in the click event for my Display Report command button:

Private Sub cmdDisplayReport_Click()

    'Open the selected report in Datasheet view.
    DoCmd.OpenReport [lboxReportList]

End Sub

Something strange happens when I click the command button and I don't know why. When I click the button it first prints out the report then opens it. The only thing with this report is that it has a parameter query data source(all of my reports do), but I can't see that being the problem. Any suggestions? Thank you all.

You should do:

DoCmd.OpenReport Me.lboxReportList, acViewPreview

.. to ensure the report opens in print preview. If you don't add the second parameter, the report should go directly to the printer.

John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"

Thank You,
That worked. I do have one question though. I did some experimenting with the VBA Code that you included. When I put Me.lboxReportList in brackets it gives me an error. But when I remove the brackets the code works. Can you explain why it does this just(for my common knowledge)?

In general, you need brackets only around a name that contains spaces, special characters, or that is the same as a reserved word (such as Date or Name). However, it never hurts to put brackets around a name. You never put brackets around an object reference -- and "Me" is a shorthand object reference to the form in which this code is running. So, the following are OK:

  Me.lboxReportList
  Me.[lboxReportList]
  Me![lboxReportList]

The following are not ok:

  [Me].lboxReportList
  [Me].[lboxReportList]
  [Me.lboxReportList]



John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"