filter combo box to select second record?

[Finedean]

Hi,
I do not know if this is possible since I have never done it before.

I have combo box that contains one field (this field contains: MemberId and MemberName like this:

12456898794, John, Smith
AB145789658, Karl, Bone
TA234587954, Anita, Sullf
54789897897, Paul, Tob

What I would like to do is allow the combo box to filter based on the memberName.
If I type A I should be able to get This line: TA234587954, Anita, Sullf Not AB145789658, Karl, Bone
I hope this is clear.
Thanks for all your help.

Dean

 

[DogLover2006]

Finedean,
Change the combo box property colum width to 1";1"
and row source should read something like "SELECT Table1.Customer, Table1.Id FROM Table1;" the customer field has to come first before the id in order to beable to typ an a and have it bring up This line: TA234587954, Anita, Sullf

 

[Finedean]

Thanks DogLover.
12456898794, John, Smith
the above name and id is one field not 2. I am trying to make the combo box filter based on John not 12456898794
I guess I'll just divide the field into two.

thanks again
Dean