Combo Box Help...

[Guest]

I am using a combo box to select records from my qry. It views 3 columns, and
it searches on last name. It shows last name, first name, and MI. I have
multiple last names, say Smith, and if I try to select the third Smith in the
list, it only brings up the first Smith in the list. What do I need to do to
make it select all the Smiths in the combo box?

 

[Al Camp]

Kisham,
You shouldn't be using LAst Name as the criteria for your lookup. Your
table design should have a unique keyfield value for each individual in your
table. For example, an autonumber field (ex. CustID).
When you do your search, it should be on this field value. That way, you
always find exactly the person you search for.
I have an example mdb file (zipped) for 97 and 2003 at the link below...
called Combo Quick Find.

 

[Guest]

I used an Autonumber. But it isn't something logical to search upon to select
an employee record. I have added the Last Name and First Name as additional
columns in the combo box, but i didn't want to scroll through a long list of
people. Any suggestions? Or is this the only way?

Thanks for your help by the way...

 

[Al Camp]

Kisham,
On my website (below) I have a downloadable file called ComboQuickFind.
It's just what your trying to do.
My setup allows the user to find (by name via auto-correct) in the combo,
but really does the lookup by ID.
By auto-correct I mean hit "C" and the combo goes to the C's, hit "Ca"
and the combo goes to any Ca's etc....
Make note of how I set up the combo query, and the columns widths.