Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Access Continuous Form only upudates by closiing and reopening

Avatar of john madigan
john madigan asked on
Microsoft Access
11 Comments1 Solution88 ViewsLast Modified:
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,