Hi My 'Utter Friends,

For the life of it, I can't seem to remember how I did this.

On a form, I have a combo box which will list all the available items which works properly.
It also allows the user to start entering a item name so that the user can narrow down
the items. (the item list is text format btw.)

What I need is on a 2nd form, I have a combo box which allows a user to select an item
by serial number. I can't get it to 'narrow' down the list when #'s are entered into it. :(

So slap me, and tell me what little thing that I am missing.

Thanks,

Aqua

Hello Aqua,

Did you look at the code on the Forms that works to apply to the 2nd?

John,

Yep, and for the life of me, I can't see whats different. :(

Aqua

Can you post your db, I am not really clear on what is going on.

Brian,

See attached.

Aqua

Look at the row source of the combo box, you are returning the prefix before the serial number. Autocompletion works off the first visible column in the combo box. Since your prefix is null, there is nothing to match against. You should either move the serial number to come before the prefix in the row source or concatenate them.

Brian,

See I told ya it was an easy one!!
I forgot about the placement.

Thanks,

Aqua

Aqua,

Sorry I was not able to get back to you for a solution I was unable to open your attachment. Glad to see Brian jumped in.

I like those kind (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)