Find Record Field

[Karyn]

When I click on my drop down box to select a record, and I select ex. Mary Smith to bring up her form, if there is more than one person with the same last name, ex. Ann Smith, John Smith and Debbie Smith, it will bring up Ann Smith first, and then I would have to click the next button to get to the right last name.

What do I need to change to bring up the correct form to match the name?

Thank you in advance for any help

 

[SomeGuy]

I had the same problem and I solved it by assigning an autonumber to each person's record so there were no ifs, ands, or buts about which record I wanted. Pulls up the right record everytime.

 

[Neal]

You just need a unique identifier for each person. The autonumber suggestion will work great, but if your table includes the person's social security number, you could use that.