How to disable query parameters when opening MS Access report?

M

myayalar

<<<Need expert advise>>>
Have created a report based on a query that has parameters set. I would
like to disable them (from the report), so that the users are not
receiving the prompt, when they open the report.
 
A

Allen Browne

By definition, parameters are values that must be supplied at runtime. If
you do not want your users to supply values at runtime, remove the
parameters from the query.

There are alternative ways to sometimes limit the report: the WhereCondition
of OpenReport is probably the most common. For an example, see Method 2 in
this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
 
Top