We help IT Professionals succeed at work.
Get Started

Access 2007 Slow on Subforms

jrogersok
jrogersok asked
on
637 Views
Last Modified: 2013-11-29
I have a database 315K that is extremely slow when using a drop-down box on a subform.  When clicking the drop-down you can literally see the records display at a rate of about 2 seconds per line.  The drop-down is bound to a query.  I have tried the following things to speed it up to no avail, so thought I would post to see what others might suggest: (This behavior does not exist when I'm running on an external drive, but when loading it on a network it crawls.)

1. Compact and Repaired the database (we do this on a regular basis)
2. Turned of Name Autocorrect
3. Turned of subdata sheets
4. Compiled the VBA code
5. Tried loading the row source for the combo box when loading the form

Any suggestions will be helpful.  It's painful to watch the users have to wait so long to select from a combo box.

Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 3 Answers and 15 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE