filter report content using vba
Posted on 2007-11-28
i'm trying to open a report filtered to a certain ref:
Dim stDocName As String
stDocName = "PAYMENTRECIEPTSBANK"
DoCmd.OpenReport stDocName, acViewPreview, , wherecondition:="TransferRef = " & Me.TransferRef
the transferref Datatype is Text because it is a mix of details which may be entered
Any Suggestion to why it does not filter the report????