Hi Terry,
SHIFT-F9
will prompt you for Query parameters again and show you the new results.
Have you thought of using a form to collect the parameters instead of typing them in as a parameter? Then you have the great advantage of choosing from combos and re-using criteria :)
Warm Regards,
Crystal
Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Terry Olsen
I use queries a lot to examine data exception cases. A good number of them accept a parameter. I usually
Right now, the only ways that I know to run them is to either double-click, enter the parameter, and view the results. To re-run the query with a different query, I either need to close the result set and double-click the query name again OR switch to design view and hit the Run selection.
Is there a different way to just double click the query name again, respond to the prompt and have the current result set be refreshed.
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar