I have a form with 12 enhanced tabs. All tabs are driven by the same view
View = 1 table with 2600 rows 1 table with 2100 (1 common column indexed - ItemNo) The form takes over 40 seconds to call up, longer at times. Tracing it shows the following Running the On Before Start - 3 seconds Then there is a 20 second period before the On After Start EEP runs The On After Start runs in 1 second (or less) Then there is another 20-30 second period before the form finally gives focus to the user. Screen is blank white in both periods above. The different tabs show records from the same view that are in different "states". I.E. One tab shows all records that are not printed. Another tab shows all records that are late. I cannot index every "state" the records are in, that would mean putting an index on 12 columns. Half of these columns have less than 5 distinct values anyway. One form button allows the user to select an item. All lists are refreshed to show the various records for that one item. This runs almost instantly, I assume using the ItemNo index. However, another button "clears" the item and refreshes each list to show all items with the respective parameter. (Not printed, Late, etc.) This process takes quite a while to refresh. Any suggestions on speeding this type of form up? Thanks, -Bob
