Hi All,

I'm attempting to find bottlenecks in a form that's terminally slow to load.

Here're the things that I know are wrong:

1. Too many controls on the form.
2. Many tables and views being opened in the DE.
3. I suspect things like refresh is being called many times.

In the long term, I know the form needs redesigning either with less controls or less tables & views or by instantiating things later.

What I want to do immediately is inspect what's being opened in the DE. Has anyone got any ideas about tactics to investigate what's happening in the DE?

Regards

Paul