Benyaw
asked on
filter report content using vba
i'm trying to open a report filtered to a certain ref:
Dim stDocName As String
stDocName = "PAYMENTRECIEPTSBANK"
DoCmd.OpenReport stDocName, acViewPreview, , wherecondition:="TransferR ef = " & 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????
rgds
benyaw
Dim stDocName As String
stDocName = "PAYMENTRECIEPTSBANK"
DoCmd.OpenReport stDocName, acViewPreview, , wherecondition:="TransferR
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????
rgds
benyaw
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
worked perfect........thank you
ASKER