Combo Box

[Lee]

How can I narrow down the list displayed in the drop down while the user
types? For example, if the list is a list of customers and the user types an
'a' then only the items beginning with 'a' should be shown etc.

 

[Marshall Barton]

How can I narrow down the list displayed in the drop down while the user
types? For example, if the list is a list of customers and the user types an
'a' then only the items beginning with 'a' should be shown etc.

Try using the AutoExpand property.

 

[Beetle]

That is the default behavior of combo boxes. If yours is not
doing that, I would guess that the Auto Expand property
somehow got set to No. If so, change it to Yes.

 

[Mike Painter]

How can I narrow down the list displayed in the drop down while the
user types? For example, if the list is a list of customers and the
user types an 'a' then only the items beginning with 'a' should be
shown etc.

Build the query for the drop down to select only type "A" (and look out for
heart attacks....)
You will have to requery the combobox after the user type is picked.

 

[Lee]

Tried that with no luck, also tried som variations on the column order and
bound column but still could not get it to work.