Thanks for the feed back everyone. I may have been a bit unclear, in that there are 12 tab pages but only one list view on each page. The data set quite small, about 4000 rows. One would be hard pressed to have a better designed form for what this situation requires.
In this case, I am willing to wait the 30 seconds to start the form as once it is started, the users can instantly move from one tab to another and do so for many functions. This form is designed to be a "work station" where the user stays for hours at a time. Each tab has information that is needed and needed quickly, so the user flips back and forth between tabs continuously with a single click, and in the present case instantly. They select information from the list views and then many other functions can be conducted via various button eeps and so forth. The only data shown on this form is the list views, but it is the "traffic control center" of the operation. The form works perfectly once started and the users are extremely happy. Since this is a "work station" form and the user will be in this one form for hours at at time, taking 35 seconds to start is minor compared to the superior efficiency and functionality they are getting with the present design. So no need to rebuild Rome in this case. As often, I try to understand the logic and working functionality of anything I do. This helps me insure that I design and code the best system I can, both now and in the future. My apologies if my question was misunderstood. I do not need to know how to make the form better, I was interested in determining what causes the form to start in 5 seconds in one case and 35 seconds in another case. This information is important to know for me for future coding. It is always best to know what to do and why you are doing it in my opinion. I do not like doing rewrites and doing it right the first time is how I strive to function. I find a good understanding of the under lying principles is what makes me efficient. Thus my question To my understanding, the form would be in a read only mode when starting up as far as the data set. (There are no editable fields in the list views) I was surprised to see the large difference in start up speed when 4 users were connected to the database versus 30 and was inquiring on why that might be the case. Not that 30 were using the form, but setting idle and only one session starting the form. Anyway, thanks again. -Bob
