I created an Access Help Desk program for my company. The main form has numerous controls, a subform and linked to another table in a database. When I open the form it takes about 32 seconds to open up(we timed it). This is very slow. I’ve run the performance analyzer on it and it said the “Form has too many controls.” All of the field controls are needed to give the proper Help Desk information.
Are there any suggestions?
Thank you.