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,