Clearing Parameter in Query

[pthoopth]

I have a query parameter that I'm running from a form and it works fine the first time. Pops up and asks me for the parameter with no problem and the query runs fine. However, if I run the same query again it doesn't ask me for the parameter - it just takes whatever I entered the first time. How do I clear this so it always asks me for the parameter?

[neileg]

Are you capturing the parameter in a control on the form?

[pthoopth]

No - I'm just using the parameter built in dialog. I works fine if I close the form and then reopen it but obviously I don't really want to do that.

[neileg]

Well then, do capture it in the form.

[pthoopth]

Thanks - but I don't want to capture it in a form. I just want to rerun the query like it runs the first time - with the built in popup.

[neileg]

Ok, having thought about this, I supect that what is happening is:

1) you have a comand button on your form that runs the query
2) When you click on this, it runs the query and the parameter dialogue box appears
3) You complete the parameter, the query runs
4) You return to the form
5) You click the query button again, but because the query is still open in the background, it simply switches the view back to the query
6) You then think the query has re-run with the old parameter, but it hasn't, it's the same query result

If you had closed the query after step 3) the parameter box would appear ready for the new parameter. There must be something in the code in the form that closes the query, so that closing and re-opening the form makes it work.