parameter prompt twice from form and listbox

[sunrunner4kr]

I have a form which is linked to a query with a criteria prompt. On the form is a list box which looks up data from this same query. So when I load the form, I am prompted to enter the criteria parameter twice.

If I deassociate the form with the query, my other textbox on the form which is linked to the query won't work. And If i deassociate my listbox with the query, it doesn't load the correct data.

Could someone please give me some advice of what I can do to stop getting the two prompts?

Many thanks in advance

Simon

 

[DCrake]

Every time you invoke the query you will be promted. You need to look at what you are actually doing so you can get it to work as expected.