Just learning Access so bear with me if this is a dumb question. I created a
parameter query that promts for a customer's account. The query works fine
and brings up that customer's account information, but I am querying 20
accounts so is there an easy way for the query to show me the dialog box
again? Right now I have to click on Design View then back to Datasheet View
to have the prompt come up again.
ahearn,
No, there is no way to do this if you are just opening the query
datasheet, apart from the way you are doing it.
However, in Access, Queries and Query Datasheets are generally regarded
as not suitable for human consumption. They are usually attended to in
the design phase of the database, but should not really be directly used
for "production" data processes. You should really be using a Form to
see the data returned by your query, by making the query as the Record
Source of the form. In this case, you can put a Command Button on the
form, with a macro or VBA procedure, which will do what you want. Just
make a simple macro with the Requery action, nothing entered in its
Control Name argument, and then assign this macro on the On Click event
property of the button, and every time you click the buttton the
parameter prompt will pop up.

Signature
Steve Schapel, Microsoft Access MVP
> Just learning Access so bear with me if this is a dumb question. I created a
> parameter query that promts for a customer's account. The query works fine
> and brings up that customer's account information, but I am querying 20
> accounts so is there an easy way for the query to show me the dialog box
> again? Right now I have to click on Design View then back to Datasheet View
> to have the prompt come up again.
ahearn - 24 Jun 2005 18:37 GMT
Thanks Steve.
> ahearn,
>
[quoted text clipped - 19 lines]
> > again? Right now I have to click on Design View then back to Datasheet View
> > to have the prompt come up again.
debsumrall - 29 Jun 2005 20:56 GMT
after running the query the first time, from datasheet view, try Shift +
F9...works everytime.
> Thanks Steve.
>
[quoted text clipped - 21 lines]
> > > again? Right now I have to click on Design View then back to Datasheet View
> > > to have the prompt come up again.
kayakfemale29102 - 26 Apr 2006 15:41 GMT
I discovered this as well and use it all the time, however, I would rather
use a one-key option. Is there any way I can easily change shift+f9 to one
key instead.
Joy
> after running the query the first time, from datasheet view, try Shift +
> F9...works everytime.
[quoted text clipped - 24 lines]
> > > > again? Right now I have to click on Design View then back to Datasheet View
> > > > to have the prompt come up again.
jnnfrspnc - 14 Nov 2005 21:52 GMT
Steve,
Your post was very helfpul. I would like to go one step further and was
hoping you could help. I have a table with two fields: customer location
and site location. So I created a form with the command button that the user
can hit to keep getting prompted to enter customer location to get site
location information. The problem I have is that the user can rerun this as
little as 2 times or as many as 50 times. So in that case we would like the
form (or maybe a report could do this) to print a log of the results from the
form. So say the user entered one location and hit the command button to run
again to enter another location - he wants to see both results instead of
having to stop and write each one down. Thanks for your help.
>ahearn,
>
[quoted text clipped - 19 lines]
>> again? Right now I have to click on Design View then back to Datasheet View
>> to have the prompt come up again.