Compiled SLOW - Step Through FAST

K

KPR

I have a fairly simple form that uses a type ahead text box at the top of the
form to filter the records in the sub form below.

The field is using the OnChange event to build a sql query that's applied to
the records below. It filters my records instantly but I then get the
hourglass for 15 seconds and it sits there and does nothing. When I step
through the code it works perfect and I get no delay.

This was working perfectly at the beginning and now it seems to be getting
slower and slower.

Any Ideas???

Thanks,
Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop slows down 5
Access 2007 Open forms with FilterOn and form fails to open 5
Form Slow, Then Fast 8
Bookmark property works when stepping through code in debug, but not when run 9
Line Draw VERY Slow (lots of lines) 2
Routine too fast for Form to Update? 1
Open form on filter 3
Anomalous MS Project behavior under XP 1

Top