Combo box problem
From: hj (anonymous_at_discussions.microsoft.com)
Date: 07/27/04
- Next message: Jim Allensworth: "Re: Selecting all items in drop-down list"
- Previous message: Jim Allensworth: "Re: Stop saving the filter entered by the user"
- In reply to: Karla V: "Combo box problem"
- Next in thread: Larry Daugherty: "Re: Combo box problem"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 12:04:02 -0700
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.
>
>What am I doing wrong?
>.
>
- Next message: Jim Allensworth: "Re: Selecting all items in drop-down list"
- Previous message: Jim Allensworth: "Re: Stop saving the filter entered by the user"
- In reply to: Karla V: "Combo box problem"
- Next in thread: Larry Daugherty: "Re: Combo box problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
