Although the Access team has worked on performance of forms throughout past and current versions, there are still ways to increase performance even more on forms, using ingenuity and VBA.
Some ideas discussed in this chapter will actually increase performance in the user's perception, which most of the time is as important as really gaining in performance.
You can do some things to increase your performance regarding forms:
If there is no CBF (code behind forms), you can specify the form as being a lightweight form by changing the HasModule property to No. The HasModule property can be found on the Other page of the form's property sheet. This property changes automatically ...