combo box function

[cheph57]

Hi, I am using a combo box in a form to allow the user to select business type categories from a separate table. It works fine except that I would like for it to display the next choice alphabetically when you hit either the beginning letter again or the down arrow. Can anyone help with this novice question?

 

[TheAceMan1]

How are ya cheph57 . . .

Haave you tried setting the [blue]AutoExpand[/blue] property of the combobox?

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cheph57]

The AutoExpand is set to Yes and it simply autocompletes the first alphabetic match in my table. I would like to be able to move to the next match by either hitting the first letter again or using the down arrow.

Thanks,

 

[TheAceMan1]

cheph57 . . .

Ohhhhh . . . I see! Not what I was thinking.

Perhaps the following link will help. Its a method where filtering of the combobox list doesn't begin until the 2nd or 3rd characters are entered:

Combos with Tens of Thousands of Records

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886