Trouble selecting records from unbound box

[premis]

I am using an unbound box on the top of a form where I would like to select a clients name and have the form populate with their info. My problem is that the box will pull up the record by last name, but only pull up the first record with that last name in alphabetical order.

Example, If I have the following names in my database

Ben Smith
John Smith
Tim Smith

If I select "john smith" from the drop down "ben smith" will show up, if I select "tim smith" "ben smith" will still show up. If I select "ben smith" the correct record would show up.

an image of the property sheet is attached

Any ideas?

Thanks!
Brad

[orange]

Does your Contacts_Extended records have a unique identifier PK?

Field 1 is the bound column.

see http://www.techonthenet.com/access/c...bind_index.php

[premis]

Does your Contacts_Extended records have a unique identifier PK?

Field 1 is the bound column.

see http://www.techonthenet.com/access/c...bind_index.php

I tried this suggestion and it still doesn't work. My database does have a unique identifier (they "key" logo, right?).

Using the steps on that link the combo box won't populate the form with any record. But if I set the bound column to "2" (last name) it will pull the record, but I still have the same problem from my original post.

[orange]

In your application do you have a field that can distinguish Ben Smith from Tim Smith? That seems to be what is missing.

Read this article for more info
http://forums.aspfree.com/attachment...achmentid=4712

[premis]

Yep. I have a unique identifier that automatically assigns a number to each record.

[orange]

Please describe that table and the fields involved. Amd how does that table and fields relate to the rowsource of the combo87 from your post #1?
.

[premis]

The "Contacts Extended" in the row source is a query that access made when I used the wizard to make the combo box. It contains all the fields as my clients table with the addition of "Contact name" and "File As". There are 50 or more fields, the main fields that are always used are.

ID, Contact Name, File As, Last Name, First Name

I hope that helps, I am a pretty big amatuer when it comes to this stuff.