Enter parameters twice in query???

[shaley86]

Hi,

I have a query that when I run, I have to enter the date parameteres TWICE. I have read other help forums that state I need to clear out the "filter" and "order by" property fields in the Query Property Sheet, which I did, so now they are empty. The query then ran fine all day yesterday. However, when I reopened it today, it's back to asking me to enter the date twice, and there is content back in those two property boxes in the Property Sheet....how do I fix this permanently?

Thanks!

 

[jzwp22]

I have never tried what you mention, but I use a different approach and do not have an issue. I use an unbound form with textbox controls to hold the parameter values. After you type values in the controls, the query refers back to them as many times as needed (of course the form has to remain open). I typically have a button on that form for the user to click to run the query that way they do not have to find the specific query in the list of queries.

You would have to modify your query to reference the form control names