Combo Box Problem

K

Kathy G

I am using a combo box to locate a record on my form. The only problem I am
having is when there are more than one person with the same last name. The
combo box will not go to the 2nd name in the list, it take me to the first
name everytime. Any suggestions would be appreciated.
 
M

Mark

Kathy,
The rowsource of your combo box should include the primary key field in the
underlying table from where you're getting the names. You can hide this key
field (which is usually an arbitrary autonumber). Now when you pick a name
from the list, it will always find that exact name because it searches for
the primary key instead of the name.


...
 
S

Steve Schapel

Kathy,

In the design view of the form, select the combobox and look at the
properties. Change the Allow AutoCorrect property from Yes to No.
Please post back if this doesn't resolve the problem.
 
Top