Combo box returning wrong results in Access 2010

[andigirlsc]

I have an unbound combo box that I set up in a form using the combo box wizard in Access 2010. I selected the option that says, “Find a record on my form based on the value I selected in my combo box.” The problem is that the combo box will not always display the correct record. It seems to only display the first record of a group of similarly named records in a table. I have found similar posts, but no solution.

Example:

    Last Name  First Name  SSN
    Smith      Alex        123-45-6789
    Smith      Jane        234-56-7891
    Smith      Mary        345-67-8910

If I select Smith Jane, the record for Smith Alex will display. I know that this has something to do with the bound column property, but I am unsure what to do to fix the issue.

What I have tried:
I tried setting the primary key as the first field, but then I could only search by the primary key, which is unrealistic for this database. Users will be searching based on last name. How do I make the combo box select whichever record I select from the drop down list?

 

[pr2-eugin]

Convert the Macro to VBA and post it here !

 

[BlueIshDan]

This is something where you might have to attatch your database.

 

[andigirlsc]

SOLVED (for now)

I scrapped the combo box and started the wizard again. Then, I set the SSN as the first column, (which is the primary key) allowed it to be hidden and the combo seems to work fine.

 

[BlueIshDan]

Woot congrats!