Here's is one solution:
Remove the parameter from your query. Instead, add code to the button that previews the report. Use something similar to this:
Dim stDocName as String, stLinkCriteria as String
stDocName = <Name of the report>
If Me.Occassion <> "<All>" then
stLinkCriteria =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.