General Form Speed Troubleshooting

[hokiewalrus]

I have one form that is opening extremely slow, I'm trying to troubleshoot why and I'm looking for some general info.

The form contains 4 subforms and one thing I'd like to do is keep the subform on the main form but not load it, so that I can keep stuff on there but diagnose if any of them are the source.

Additionally if there are any common steps to diagnosing form speed that would be awesome.

I've searched around but all I've been able to find is tips on general speed (disable AUTOCORRECT and no subdatasheets and the like) but I'm having a problem with one specific form.

All 4 subforms must be displayed at load and those subforms are based on queries, some of which are in turn based on other queries. I'll worry about how to solve the specific item later, right now I just want to try to drill down to what is causing the problem.

 

[ghudson]

Try removing one sub form at a time and see which one is causing the slowness. It might just be the time it takes to load the records. Queries querying queries can be slow if there are a lot of records and criteria involved.