Best to ask a new question as a separate thread.
If you don't want the parameter dialog popping up, then I presume you want
it to pick up the parameter values from an open form. You can do that by
specifying parameters like this:
[Forms].[Form1].[Text0]
For information on a better way to do it, see:
http://allenbrowne.com/ser-62.html
The last section of that article illustrates how to do it with a parameter
query reading values from a form, if you really want to do it that way
instead of building a filter string.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"klim1167 via AccessMonster.com" u60492@uwe wrote in message
news:a8eaf7585359e@uwe...
Thanks a lot, Allen.
Can you give me an example how to implement a parameter query in a form
without a pop up window?