I have seen this with a lot of combo boxes that need to be populated on the form, but you say this delay occurs BEFORE the comboboxes are populated? I ran into this on the primary form in an app and I elected to load the form when the app launches and hide it. When the user opens the form it actually just pops up from its hidden position. I had to code for all cases where it could be closed though and hide it instead. I had 10 comboboxes that HAD to be populated and I didn't want the delay everytime the form loads. This might not work for you, but it was the only solution I could come up with at the time. Is there anything else you could activate or process while the load processes to at least prevent the user from having to wait? Then it could load in the background since it appears from the other thread that you have looked at a lot of options for optimizing the select statement already.


Tracy

>This is related to thread #618884 regarding a long-running SQL, but it seems that some of the performance issue is happening when the form opens. I have set NoDataOnLoad to .T. for all tables in the DE and set the AutoOpenTables to .F. also. I put a Set Step On in the form's Init. The form takes almost 2 minutes to open before hitting the Step command. There is no code in the Load event. Any ideas? Thanks!
>
>Regards, Renoir