Split database crawls on Forms with subforms/combo boxes

[Guest]

Company database that was working fine up to a few days ago. On forms that
have several subforms, the time to cycle through a record is horrendous. It
takes two minutes or more to display the next record. If viewed in datasheet
mode, all the records display quickly but when a record is selected then
moved back to form view, delay delay delay.

Also, when clicking into a combo box it takes the same amount of time to
display the possible selections.


I am asking for troubleshooting ideas. BTW, I have already implemented the
open table in the background to have a persistent connection to the back end.

thanks

gavin hill

 

[Albert D.Kallal]

I am asking for troubleshooting ideas. BTW, I have already implemented the

open table in the background to have a persistent connection to the back
end.

That trick usually fixes this performance problem. You sure you done that
right?

2nd, if above don't work, then work through the following list one by
one....

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

 

[Guest]

Thanks Albert.

I have the form opening hidden using the "On Load" Event of the Main Form
used as a starting point. I don't use the switchboard. I verified it opens by
maiking it acWindoNormal and starting the database. It opens and displays the
one record in the table it is linked to. I believe that is all that is
necessary?

I will work through the FAQ and respond back. I appreciate your help.