Supressing select parameter dialog box - need quick reply!!

[oliaccount via AccessMonster.com]

hi.
A very minor bug really, but it's really annoying me. Can anyone tell me what
can be done to stop the select pparametre message coming up every time the
report starts? Obiously, I've had this before, but I can't find anyway round
it this time. Some sort of code would proberly do it. (I've seen code that
subpresses warnings, so I guess the same can be done here.)

 

[Allen Browne]

Remove the parameter from the query.
Instead, use the WhereCondition of OpenReport.

Here's a couple of examples:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
and:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

The 2nd one shows how to use a text box on the form as a parameter if you
prefer to do it that way.