Combo Box Problem

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

Guest

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.
 
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.


...
 
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.
 
Back
Top