I need some help in a very simple problem, but I cant seem to get it to work for me. I am trying to open a report and have it filter wkstorenumber=3268. It will open report, but will not put a filter in. It is almost like it skips that part. Any help would be greatly appreciated.
Thanks in advance.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "1mothlyreportforstore"
stLinkCriteria = "wkstorenumber= " & "3268"
DoCmd.OpenReport stDocName, acViewPreview, stlinkcriteria