Hi, Just upgraded a database from XP to Access 2003.

It has a form with a button that calls some code to open a report. This worked fine in XP. However after the upgrade when a user clicks on the button, access now cancels the action. Help!

The code is below, not much is there? :-)

"OpenReport action cancelled"

Private Sub cmdPrint_Click()
On Error GoTo Err_cmdPrint_Click

    DoCmd.OpenReport "rptSupplierDetails", acPreview, , "[DetailsID]=" & Me!DetailsID

Exit_cmdPrint_Click:
    Exit Sub
Err_cmdPrint_Click:
    MsgBox Err.Description
    Resume Exit_cmdPrint_Click
End Sub
++++++++++

Cheers
John

Usually vague errors like that means you misspelled something. Try using the intrinsic constant acViewPreview instead of acPreview. Perhaps that's giving you the error.

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