Dynamic Query needs parameter two times!

[Gijs]

Hi guys,

Somtimes i have a problem with dynamical queries. For some of these i need to put in the same parameter value two times, before it works.

Does anyone knows why this occures?

 

[Brianwarnock]

If you use prompts you will be prompted as many times as the parameter is referenced, which is one of several reasons why I ran my queries from a form with the parameters being supplied from a control on the form.

Brian

 

[CJ_London]

or you have typos