I have an application that gets the job done. But I'm pretty sure I'm not optimizing performance. The app is an interface with Access in which I'm retrieving data into textboxes. I have 9 forms with anywhere from 30 - 100 controls on each. There are nine modules (.bas) also. It was suggested before that I may want to use resource files to store the modules and forms. I look into it, but was unable to get to first base. The forms resemble financial data in an excel spreadsheet like fashion. A variety of combination makes up each form, with corresponding module.

Any ideas or help to spruce things up would be appreciated. Thanks.