Avatar of john madigan
john madigan

asked on 

Access Continuous Form only upudates by closiing and reopening

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,
Microsoft Access

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon