I have a database that has an initial form and then 4 sub-forms. When a person calls in and gives their SSN, it is input and then the name auto fills in from another table. Then the sub-forms appear with history information from four different areas on this employee. This is so there is an accurate record of all the calls placed by this person. I currently have the sub-forms become visible after the SSN is input and then set back to blank and not visible after they cycle to a new call. Theproblem is that when they load the initial call it takes 45 to 60 seconds for the form to load. After it is loaded it is quick. I have the Option Explicit at the top of each module but do not know what it means when it says you must explicitly declare all variables using the Dim, Private, Public
, ReDim, or Static statements. I have Private Sub before each action is that all it wants? I don’t get an error. I need to speed it up.