I have multiple forms in my database but one of them has been giving me a
performance problem (Very slow) recently. I have tried shortening form and
removing subforms but this did not help.
When I run performance Analyzer, it suggests I create some relationships
between tables but I already had set these relationships up in the query on
which the form is based.
Interestingly problem is not always present but it does recur when I "compact
and repair database".
Any ideas? Thank you for the help in advance.