Must exit Access for query to work a second time

[mwc0914]

I am trying to learn Access 2010. I am trying a basic search first, with a button on the form to trigger the query. It works when I run it the first time. But when I go back to my form and change the data value in the text box and click on the button again, the query results are still from the original query. How do I get the query/form/button to work when changing query values, without having to exit Access, then start up Access again and enter new data for the query?

[June7]

How is the search performed? Do you have a parameterized query or do you build filter string with VBA. Fully describe the process and show code or provide db for analysis. Follow instructions at bottom of my post.

[mwc0914]

Form contains 2 text boxes (I am currently only using one of them for the query). Form contains a button to run the query. Query is parameterized. No VBA at all.
I open Access and go to my form.
I enter a value in the text box and click on the button to run the query.
Query is performed and returns the correct dataset.
I go back to the form and change the value in the text box and click on the button to run the query.
I go to the query results and they are the same from the first query.

If I exit Access, then come back in and enter a new value in the text box, then the query works.
So, in order to perform subsequent queries with different values, I must exit Access and come back in each time. I should not have to do this I would think.

[June7]

So you are opening a query object instead of a form or report bound to the query?

Need to close the query before changing filter criteria then reopen.

Or modify code to replicate the ribbon RefreshAll. The only method I can find to do that is:

SendKeys "+({f9})"

Or use form or report and Requery:
Forms!formname.Requery