Marchese Il Chihuahua
Reputation: 1129
Syntax for opening a report
I am getting a Runtime 2465 error message trying to open a report using the following routine:
DoCmd.OpenReport "rptSprechi", acViewPreview, , [qry_rptsprechi].[WasteType] = "UE", acIcon
Upvotes: 2
Views: 54
Answers (1)
HansUp
Reputation: 97101
The fourth argument (WhereCondition) is supposed to be a string value. Yours looks wrong to me.
Try it this way ...
DoCmd.OpenReport "rptSprechi", acViewPreview, , "[WasteType] = 'UE'", acIcon
Upvotes: 2
Related Questions
- MS Access button with VBA doesn't open report, it prints
- Opening a Report With a Filter
- MS Access - Docmd.OpenReport
- Opening Form From Report
- MS Access reports issue?
- How can I call the function of Report in VBA?
- Normal open file statement in VBA
- Reports in Access 2010 Building with VBA
- VBA MS Access Open Report in "Report View"
- VBA code to create a report in MS Access