Forms taking a long time to load

[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

 

[Jeff Conrad]

Hi,

See if this great article by MVP Tony Toews helps:

http://www.granite.ab.ca/access/performancefaq.htm

Good luck,
Jeff Conrad
Bend, Oregon

 

[Oscar]

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

 

[Jeremy Dove]

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.

 

[Bas Cost Budde]

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.

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.