Combo Box not Allowing User Entry

[Guest]

I have a combo box on a form that is used to query and populate a subform.
The combo box is restricted to distinct customer names in the customer table.
The box is set to yes for "Limit to List" and "Auto Expand", but when the
user types a name the box will only except the first character. For example,
if the customer that is being entered is "Bob's Towing" and the users starts
typing "bob", the box will go to the first "b" entry, then the first "o"
entry, then the first "b" entry, but will not allow "bob" to be typed or go
to the first customer name that starts with "bob". And if there are no
customers that begin with "o", the error message "Run time error '2237': The
text you entered isn't an item in the list."

I think it might have something to do with the subform because I have other
forms that use this same combo box logic but populate the detail section of
the form, instead of a subform and they all work correctly.

 

[kingston via AccessMonster.com]

It sounds like you implemented code based on the combobox's .OnChange event
rather than the .AfterUpdate event.

 

[Guest]

EXACTLY!!! You made my day. Now if I can only find time to change all my
combo boxes to AfterUpdate refreshing instead of OnChange.