resetting query value

[jerry28ph]

Hi,

After running the query, and you want to input another set of criteria, how can we reset the query? Please need your help.

Thanks,
Jerry

 

[John Big Booty]

How are you setting the criteria?

 

[jerry28ph]

thru my query and main form. when you run the query and the value showed on the screen and once you change your criteria on your main form, does the value of your query be overwritten by a new value? Pls correct me if i am wrong, i tried it and it was overwritten by a new value.
THanks.

Jerry

How are you setting the criteria?

 

[neileg]

Every time you run the query it should read the criteria in the form. It follows that if the criteria have changed, you will get different results in your query.