Combo Box

  • Thread starter Thread starter Lee
  • Start date Start date
L

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.
 
Lee said:
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.
Click to expand...


Try using the AutoExpand property.
 
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.
 
Lee said:
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.
Click to expand...
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.
 
Tried that with no luck, also tried som variations on the column order and
bound column but still could not get it to work.
 
Back
Top