By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,836 Members | 1,732 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,836 IT Pros & Developers. It's quick & easy.

Another look-up combobox speed question

P: n/a
I'm using Access 2000. I've got a basic look-up combobox on a form
(moves to selected record on update). The key field and the look-up
field are both indexed, and the speed if fast enough for me. I then go
into the Row Source editor for the control and make it so my look-up
field is sorted. Still fast enough, no problems yet. Then I go in and
set "is not null" for criteria for my look-up field. NOW IT IS SLOW!

It isn't actually slow to do the look-ups, but for some reason just
moving the mouse over the control causes a bunch of CPU activity to
occur. The mouse changes to an hour-glass for a full second or two,
everytime I move the mouse over the control.

Anyone seen this before? Know of a fix?

I don't need the look-up lists to by dynamic or anything. I can accept
that the query may take a little while. So if it is possible to just
do a STATIC query, and then use that for the look-up list (should be
really fast after that), that sounds good to me.

Mar 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.