form loads slow - 7 seconds

[Robert Blackwell]

I have a search form that takes 7 seconds to load. At first, I thought it
was taking so long because it would show all contact records (11k+) even
before a search was performed. Then it was changed so that it wouldn't show
any records until a search was performed but it is still taking 7 seconds to
load. The searches themselves are almost instant. For the most part, every
other form loads right away so I don't know.

I didn't design the form I'm just trying to help troubleshoot. For what its
worth the db is split and I'm not accessing the fe through a network share,
its on my desktop.

Here's some information about the form. There's a dropdown list for
specifying what to search for, then obviously the search box. Under that
part, is the results section which is context sensitive. Depending one what
you chose in the dropdown, the results show differently. I believe the
dropdown options are populated by checking the 2 tables I wanted to search
by, and then creating a search option for each cell that is available.

Thanks for any comments and suggestions.

 

[Dirk Goldgar]

I have a search form that takes 7 seconds to load. At first, I
thought it was taking so long because it would show all contact
records (11k+) even before a search was performed. Then it was
changed so that it wouldn't show any records until a search was
performed but it is still taking 7 seconds to load. The searches
themselves are almost instant. For the most part, every other form
loads right away so I don't know.

I didn't design the form I'm just trying to help troubleshoot. For
what its worth the db is split and I'm not accessing the fe through a
network share, its on my desktop.

Here's some information about the form. There's a dropdown list for
specifying what to search for, then obviously the search box. Under
that part, is the results section which is context sensitive.
Depending one what you chose in the dropdown, the results show
differently. I believe the dropdown options are populated by checking
the 2 tables I wanted to search by, and then creating a search option
for each cell that is available.

Thanks for any comments and suggestions.

It could be in the queries needed to populate the combo boxes, but one
thing to check even before that is whether Name AutoCorrect is causing
the problem. Click Tools -> Options..., go to the General tab, and see
if "Track name AutoCorrect info" is checked. If it is, uncheck it,
close the database, open it again, and see if your search form opens
more quickly.

 

[Robert Blackwell]

I just looked for that but it is already unchecked.

 

[Dirk Goldgar]

I just looked for that but it is already unchecked.

The next thing I'd check is the rowsource queries behind any combo or
list boxes, and the form's recordsource query if it isn't unbound. I'd
probably remove each in turn to see if the form's load time is reduced.
If removing a rowsource query speeds up the form's load significantly,
then look at that query to see what makes it so slow.

If I understand what you said about the combo box you use to determine
what to search, that's a very likely candidate. You may be filling its
value list from code, or else using a custom rowsource function. In
either case, maybe that code is taking a long time. If you can narrow
the problem down to that, post the code. If it's not code being used,
explain more fully what you're doing with this combo box.

 

[Robert Blackwell]

Thanks for the help. they were able to fix it.