How to improve subform refresh rate?

[JenSGT]

I have a form with 10 tab pages. On each tab page, I have at least 2 subforms on it. I have a search button on the main form where it will search for the relevants records based on user data input and display the associated tab page.

My db is place on the file server.

After I hit the search button, I noticed that the subforms in the current page will flicker and refresh at least 2 times before showing the new data in the new page.
This happens when Im using a laptop. When using my desktop, I do not see such issues.

How do I improve the subform refresh rate such that no flickers will be seen when displaying the new data?

Any help & tips are appreciated.

 

[boblarson]

Try putting

Application.Echo = False

before your code and then

Application.Echo = True

at the end of the code that is refreshing it.

 

[JenSGT]

After applying your tips, my users did not complain.

Thanks, Bob.