I have an extremely complicated form which allows a uses to create quotations.
On the form is a tab control with 8 pages, with sub forms and sub sub forms on each page.
It runs fine(ish) on my machine (i5 + 6gb ram) but I am concerned about performance on the clients network.
I just need to squeeze every bit of performance out of it.
When it loads, the filter is QuoteID = -1 so there are no records for the main form - this filter is amended by a combo afterupdate.
Is there any difference in performance when having the form / subform and sub sub forms record sources as save queries rather than embedded sql??
Any suggestions most welcome.
PS - NO, i can't simplify it - it has 100+ hours of time input so far and has been developed for the clients requirements - I have already reduced the functionality to the minimum!