Combo Box based on last and first names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to pull records based on last names. Using the toolbox, I
created a combo box with Last and First names. The wizard created an
AfterUpdate event that finds the first last name (FindFirst). However, my
records can have duplicate last names. If I click on other last names/first
names in the list, I always get the very first last name in the list. Can I
modify this combox box to be based on a combination of Last Name and First
Name so that it will pull the appropriate customer? Or will I need to create
a new combo box?
 
I want to be able to pull records based on last names. Using the toolbox, I
created a combo box with Last and First names. The wizard created an
AfterUpdate event that finds the first last name (FindFirst). However, my
records can have duplicate last names. If I click on other last names/first
names in the list, I always get the very first last name in the list. Can I
modify this combox box to be based on a combination of Last Name and First
Name so that it will pull the appropriate customer? Or will I need to create
a new combo box?
Click to expand...

Not only can your customers have the same last name, but different
customers can have the same last and first name. After all, there are
many John Smith's in the country.

Your combo box should show the CustomerID (can be hidden), The
customer last name, first name, and some other field (address, SSN,
Phone Number, etc) that will differentiate the customers from one
another.
Have the bound column be the CustomerID column. Then when you select
the correct customer, it is that customers ID that is searched for not
his name.

To hide the CustomerID column, set the Combo's Column Width for that
column to 0". Make sure the Bound column is the CustomerID column.
 
Thanks for the response. (getting close)

I want to be able to type in a last name and have the listing bring up the
CustID Last Name First Name ... (as fredg suggested)
for customers with that last name.
Then, I will click on the desired customer to pull the entire record.
However, now when I type the last name it does not work since it is bound to
the CustID.

Is there a way to resolve this?
 
Back
Top