ComboBox Issue_AutoExpand

[KerryDee]

Hi I am looking for help on a weird issue. I have a combox with the following example:

Kalie
Kerry
Kevin
Kerwin

Whenever I type K the combox is populated nicely with Kalie in my field. However, when I type Kerry, Kevin, Kerwin the combox is not displaying them although they show up on my combox list. I think the combox is only recognizing the first letter character.

Autoexpand is already set to Yes.

Any help will be appreciated.

 

[MarkK]

What happens when you type "Kev?" Does it show "Kevin?"

 

[KerryDee]

Hi thanks for responding and your question. No, when I type Kev nothing shows up.

 

[JHB]

Sound strange, post your database with some sample data, zip it.

 

[missinglinq]

When thing don't work as they obviously should, you have to think about corruption! Although we usually think of Forms, and even entire Databases, when we speak of corruption, Controls, such as Comboboxes, can and do become corrupted, and seem particularly susceptible to this during app development.

The test/cure for this is short and simple...delete and then re-create the Control.

Linq ;0)>

 

[KerryDee]

Hi thanks I deleted and recreated the combox but got the same problem. I will post the sample database.

Thanks.!!!

 

[JHB]

You didn't tell you've some code behind the OnChange event, that is the what cause the problem, move it to the AfterUpdate event.

 

[KerryDee]

Awesome!!!! It works perfectly. Thank you so much!!!!

 

[JHB]

You're welcome good luck.