Combo Box AutoExpand

[CD Tom]

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

[TheSmileyCoder]

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.