Filter not being passed

[GraeagleBill]

I can't figure out why a filter expression is not being passed to a report. In the segment of code below, I verify the contents of the filter string with a simple display:

Public Function lbl12()
MsgBox FilterName
DoCmd.OpenReport "lblAddrLabels12", acViewPreview, FilterName
End Function

Likewise, when the report opens:

Private Sub Report_Open(Cancel As Integer)
MsgBox Me.Filter
Me.FilterOn = True
End Sub

The filter is correct in the statement before the DoCmd, but empty when the filter is displayed when the report opens.

I don't know how much more simple this could be, yet I'm mystified as to what is happening. (The RecordSource for the report is clearly defined.)



Any ideas?

Thanks,
Bill

[orange]

Bill,

Does this help?

Open the report with the filter info.
http://www.techonthenet.com/access/r...filter_rpt.php

[GraeagleBill]

That's essentially what I'm doing. The filter string in my post "Filtername" is Dim'd as string and in the current case the value of the string is something like "Business = True".

[GraeagleBill]

The filter expression is the 4th argument to DoCmd.OpenReport, NOT the 3rd!!!!!!!!!

The 3rd is the filter name...............not sure at this moment that I've yet learned the difference.