Combo box problem

[hj]

Hi Karla,
I think you need to add the Customer ID to the list for
uniqueness and bind the list to the table through that
field.

-----Original Message-----
Hello,

I have a combo box on a form that selects customers from

the Customers Table and then displays their current
information (address, etc.) on the bottom part of the
form. Each customer has a unique number, which is the
primary key.

The combo is set up to show Last Name, First Name and

Phone #. The problem I am running into is that we have
several customers with the same last name (i.e., Bob
Brown, Susan Brown). When I click the combo, it will
allow me to select Susan Brown, but only Bob Brown's
information shows up on the bottom of my form since he is
the first one in the list.