Combo box lookup

[CY]

I am trying to add a combo box on my form to choose an item to display. It
lists the place name and state. So when I pick a place, it displays
demographics for that place. The problem I run into is that there are some
place names that appear in multiple states. For example there is an
Abbeville in GA, AL, LA. When I pick Abbeville, it shows the first one in
the drop down box, regardless of *which* Abbeville I choose in the combo
box. What can I do to fix that?

Thanks...

 

[Mark]

If your records have a unique primary key, the combo box wizard should have
been able to build the code to find and display the exact record you chose,
no matter how many "Abbeville" entries there are. It sounds like you're
searching on the city name instead of a unique record identifier.