I have a combo box on a binding control. It is bound to a name column in my dataset. It works like it should, but I need the autocomplet to be able to find names by either first name or last name. For example, if I have two names in the name column,
John Smith and
My user then types in "Jo", I need the dropdown to have both John Smith and Bob Jones listed. Because J and O are the first characters in both a first name and the last name.
Anyone know how I can do this with autocomplete?