Combo Box Auto Expand (Access 2000)

Topic

New Reply

There is a combo box on a subform whose control source is an simple SQL statement where the bound field is the key of the query’s underlying table. Nothing complicated at all. Properties Auto Expand =Yes, Limit to List = Yes. It does fills in the combo box from the list with the first value matching the first character that is typed.

However, as additional characters are typed, it does not change the value displayed to match all the characters typed. It treats every character typed as the first. So if Pr is typed, it navigates to the P entries and then immediately navigates to the R entries, not the Pr entries.

Does anyone have an insight into this problem?

Thank you.
Thomas W

Reply | Quote

Replies

Do you have any event procedures for the combo box and if so, what are they?
Do you have an On Timer event procedure for the form or subform?

Reply | Quote

I have an OnChange Event that populates other fields on the subform dependent on the combo box entry.
This use to perform properly, but maybe I should attach that code to another event for the combo box? Which one would you recommend?
There is not an OnTimer Event for the subform or parent form.

Thanks for your reply, Hans.
Thomas W

Reply | Quote

You could try the After Update event instead of the On Change event to see if it works better.

If not, could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote

Thank you so much, Hans – this worked like a charm.

ThomasW

Reply | Quote