filter for a report

[Micron]

Me neither. Have used it for multiple assignments to variables to condense things on fewer lines, but never as method parameters. Didn't know this would allow anyone to omit parameters either. Or does it? No answer yet as to what the fix was.

[June7]

Yes, can eliminate parameters. Tried it. It works.

Code was moved from beginning to end of procedure:

    DoCmd.OpenReport ReportName:="rptMonthlyCircleLog", View:=acViewPreview, _
        WhereCondition:="ID=" & Me.ID
    Exit Sub

ErrHandler:
    ' Don't show error message if report was canceled
    If Err <> 2501 Then
        MsgBox Err.Description, vbCritical
    End If

In its place:
DoCmd.OpenReport "rptMonthlyCircleLog", acViewPreview, , "ID = " & ID

Line removed: On Error GoTo ErrHandler

Although doesn't explain why was not opening filtered before. And how did it even hit the Outlook code with that Exit Sub there? Was the posted code the actual code?

Why retain the second OpenReport line?