Queries Prompting for Input Twice

It sounds like you may have entered query parameters in design view (Query >
Parameters...) that are not spelled exactly the same as the entries on the criteria line.
Look for extra spaces, especially at the beginning of the query parameter.

______________________________________

"JBrow" <j@jdp.coj> wrote in message news:VPipb.88601$HS4.760157@attbi_s01...

I have a query that asks for 3 sets of parameters. Works fine until I have
a second query which uses this query as its source. When I fire the second
query, the user is prompted for the 3 input parameters twice in a row. This
has happened in a few cases. In some cases, the set of parameters loops up
to 4 times before running the query. Any thoughts would be great! Thanks!

Hi,

It may not be a problem with spelling. It seems to happen if the
underlying table is changed in some way, possibly sorted
differently. I have not spent time researching the reason as it
happens very infrequently.

The solution that I found that works is to rename the parameter.

eg if it is say [Enter Customer Number] change to say [Enter Cust
Number]. This seems to work in our case for up to one or two years
and then something changes and it needs to be fixed again.

I hope this helps.

Peter

Tom Wickerath wrote:[color=blue]
> It sounds like you may have entered query parameters in design view (Query >
> Parameters...) that are not spelled exactly the same as the entries on the criteria line.
> Look for extra spaces, especially at the beginning of the query parameter.
>
> ______________________________________
>
> "JBrow" <j@jdp.coj> wrote in message news:VPipb.88601$HS4.760157@attbi_s01...
>
> I have a query that asks for 3 sets of parameters. Works fine until I have
> a second query which uses this query as its source. When I fire the second
> query, the user is prompted for the 3 input parameters twice in a row. This
> has happened in a few cases. In some cases, the set of parameters loops up
> to 4 times before running the query. Any thoughts would be great! Thanks!
>
>
>[/color]