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

Combo Box AutoExpand

100+
P: 434
I've been using the combo box in my forms and haven't ever had any problems but lately been having problems with the autoexpand. Here's what is happening. I have two combo boxes on a form one looks up by the customer number and the autoexpand works find on that, when I type in 19 or something it jumps to the 19..... number, I also have a combo box that looks up the customer by their last name, In this box when I start typing in the last name nothing happens it takes until I have typed almost the complete last name for it to jump to that name. I'm using access 2007. The autoexpand is set to yes and I've even tried setting the Limit to list to yes but that doesn't make any difference. I was reading that this is a problem in earlier version and that using a Distinct in the SQL statement would fix the problem, but that doesn't work either. Any suggestions would be appreciated.

Thanks
Feb 3 '10 #1
Share this Question
Share on Google+
1 Reply


TheSmileyCoder
Expert Mod 100+
P: 2,321
Try to add an index on the field. Index will make adding new users a tad slower, but then again, you probably don't add new users as often as you add new records.

The index will make querying on that field alot faster.
Feb 3 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.