<div>
Refresh does not rerun the query. &nbsp;It simply &quot;refreshes&quot; the existing recordset so you will see any updates or deletes (they will say #deleted#). &nbsp;It will not even pull in new records because it works only with the existing recordset.<br />
<br />
If you changed the criteria, you want to rerun the query so you will need to use the Requery method. &nbsp;Many people mistakenly use these interchangeably so you'll see lots of bad advice regarding them on the internet. &nbsp;One other thing to keep firmly in mind is that if you Refresh or Requery a form, Access will save the current record if it is dirty. &nbsp;Again many people tell you to use Refresh or Requery to save a record. &nbsp;That is incorrect. &nbsp;Although the record does get saved, both can have unexpected side effects such as repositioning a continuous or DS form.
</div>


<div>
I put in a button on the form and with this code:<br />
<br />
Forms![Home].[Form].Requer<wbr />y<br />
<br />
So I go to the query and put in &quot;5&quot; for the ClientID Certeria - run the query - it returns back only records with ClientID = 5<br />
<br />
Now I go back to the HOME form and click my button - it runs the <br />
Forms![Home].[Form].Requer<wbr />y<br />
but all the records are still showing.<br />
<br />
if I exit out of the form then come back in the records on the form are now filtered.<br />
<br />
Could I have some property on the form set up wrong?<br />
<br />
Thanks,
</div>


<div>
Personally, I rarely allow multiple forms to be open (visible) at one time. &nbsp;It simply confuses the user and causes issues like this. &nbsp;If you want to leave the second form open, then the code in the first form is going to have to check to see if the second form is open and if it is, close it and then reopen it. &nbsp;No requery would be necessary.
</div>


<div>
&lt;&lt;Forms![Home].[Form].Requ<wbr />ery&gt;&gt;<br />
<br />
&nbsp;Correct syntax is:<br />
<br />
&nbsp;Forms![Home].Requery<br />
<br />
or when in the form:<br />
<br />
&nbsp;Me.Requery<br />
<br />
Jim.
</div>


<div>
I have only 1 form called &quot;HOME&quot; &nbsp;- I have one query called &quot;qryREVIEWS&quot; that is the Record Source for the HOME form. &nbsp;I don't have 2 forms.<br />
<br />
The qryREVIEWS determines which records will show on the form. &nbsp;When I add a number to the criteria of ClientID = 5 - and I run the query it returns just the records for ClientID = 5. &nbsp;Now I save the query - close the query - go back to my form and do a requery of the form - it does not change <br />
<br />
But if I close out of the form and open it again it shows the filtered records.<br />
<br />
So for some reason when I do a Requery on the form it is not pulling the data from the filterd qryREVIEWS query - unless I close the form and reopen it.<br />
<br />
I have done this a bunch of times before - can't figure out what the issue is?<br />
<br />
Any suggestions?
</div>


<div>
I changed my button to Forms![Home].Requery - still have the same problem - only will change to reflect filtered query if I close and open form.
</div>


<div>
Could this be an issue with a continuous form? &nbsp;Do I need to put in some code to close then open it?
</div>


<div>
your suggestion using the me.Filter worked - it is filtering the HOME form correctly. <br />
<br />
I put textbox on the form [txtClientFilter] &nbsp;that I can put in a number so my code is:<br />
<br />
&nbsp; &nbsp; Me.Filter = &quot;[ClientID] = &quot;&nbsp;&amp; Me.txtClientFilter<br />
&nbsp; &nbsp; Me.FilterOn = True<br />
<br />
Now how would I use the me.Filter .... &nbsp; &nbsp; &nbsp; &nbsp;to remove any filter so I can see all the records? &nbsp;Do I just change the filter to False?<br />
<br />
Thanks,
</div>


<div>
just found this to take off the filter<br />
<br />
DoCmd.RunCommand acCmdRemoveFilterSort<br />
<br />
it works great now - I can filter the form.<br />
<br />
Thanks for your help - always better to keep it simple.
</div>


<div>
I usually just add a button with the clear filter image and in the Click event of that button:<br />

<pre><code class="code-1 nolinks" id="code-20-42382147-1"><span>Private Sub cmd_ClearFilter_Click</span>
<span></span>
<span>    me.filter = &quot;&quot;</span>
<span>    me.filteron = false</span>
<span></span>
<span>End Sub</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I have a continuous form called &quot;HOME&quot; that the record source is a query called &quot;qryReviews&quot;. &nbsp;The query shows RevieID, ClientID<br />
<br />
When I put in a value for ClientID in the Criteria of the query - then save &amp;&nbsp;run the query - the query show only records where ClientID = 5 - so that works.<br />
<br />
But when I go back to my HOME form and click refresh all it still shows all the records. &nbsp;If I x-out of the HOME form and then open it up then it shows the records that are showing in the query - ClientID = 5.<br />
<br />
Not sure why the form is not updating after i run the underlying query and select Udate All &nbsp;- and why I am having to reload the HOME form to show the correct records?<br />
<br />
Any suggestions - Thanks,
</div>
</div>


I have a continuous form called "HOME" that the record source is a query called "qryReviews".  The query shows RevieID, ClientID

When I put in a value for ClientID in the Criteria of the query - then save & run the query - the query show only records where ClientID = 5 - so that works.

But when I go back to my HOME form and click refresh all it still shows all the records.  If I x-out of the HOME form and then open it up then it shows the records that are showing in the query - ClientID = 5.

Not sure why the form is not updating after i run the underlying query and select Udate All  - and why I am having to reload the HOME form to show the correct records?

Any suggestions - Thanks,

Access Continuous Form only upudates by closiing and reopening

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.