Forms taking a long time to load

  • Thread starter Thread starter Jeremy Dove
  • Start date Start date
J

Jeremy Dove

The problem I am having is that my forms are taking a
long time to load.

Now there are alot of fields on them, and some of the
forms are based on mulitple table queries.

I am just wondering if there is any thing i can do to
speed up the transition through the pages as it is so
slow.

I have compacted the database. I have split the database.

Does anyone have any ideas
 
I've found that by removing any DISTINCT statements from
my queries and using the distict on the forms itself when
using a query, helps tremendously with the speed forms
open.

just a thought
 
Not to sound like a rookie but what are Distinct
statements? I mean if you mean option explicit, i have
those in my forms already. That did help some but not to
much though.
 
Jeremy said:
Not to sound like a rookie but what are Distinct
statements? I mean if you mean option explicit, i have
those in my forms already. That did help some but not to
much though.
Click to expand...

No, DISTINCT sits in queries. You can see that in sql view (takes a
little time to grasp how to read that, though) and in the property sheet
for the query: distinct values.
 
Back
Top