Most interaction between the user and your application happens through forms and reports. Each open form or report in your application uses memory and requires some disk activity. Paging The following tips can reduce the amount of time the user spends waiting for a form to load and to switch between pages. The number and type of controls on a form can greatly affect the time it takes for the form to load.
Loading controls is the biggest performance cost when loading a form.
Where applicable, reuse controls on your form in multiple situations. Avoid overlapping controls. Group the controls on pages instead of displaying them all at once. That way, for forms that must contain many controls, Microsoft Access doesn't have to generate all the controls at the same time. A form without a form module loads more quickly and occupies less disk space than one with a form module.