Autocomplete combo box on Access 2007 form doesn't get past first letter

[newbieX]

cbo_Office is a drop down combo box on a data entry form. Its property sheet looks like this (I think I got all the pertinent info)

Rowsource = SELECT DISTINCT Primary.Office, Primary.Room FROM Primary ORDER BY Primary.Office;
Control Source = Office
Bound Column = 1
Limit to List = No
Allow Value List Edits = Yes
Auto Expand = Yes
Column Count = 2


Column Widths 1";0"

I am trying to type the primary district's name into the combo box and it only recognizes the first letter. Thus if I want to go to District "Central", when I type C it goes to the first record starting with "C"; however, when I type the next letter "E" it goes to the first record starting with "E" rather then "CE"

Am I missing something here or is it that it simply can't be done in Access 2007.

[June7]

Never encountered that with a combobox. That is more like listbox behavior.

What is the destination table? Are you sure you have the ControlSource set to correct field?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Missinglinq]

Although we usually think of Forms or entire Databases when we speak of corruption, individual Controls, such as Comboboxes, can and do become corrupted. The test and the fix are one and the same; deleting the Control then re-creating it! If it was corrupt, you've verified the fact and solved the problem! If not, you've only lost a minute or two!

Linq ;0)>

[pbaldy]

Also make sure there's no code running in the change event that might be interfering with the auto complete. I've never seen this behavior either.

[newbieX]

Figured it out. I had a Me.Refresh in the On Change event. I put it in the After Update event instead and everything worked fine. I'm guessing every time you hit a letter it triggers the On Change event. Learn something new every day (or hour it seems with coding)

[pbaldy]

You are correct, the change event fires with each keystroke. Glad you got it sorted out.