Finding a record on a from with a combobox

K

Kathy G

I have used the wizard to set up a combobox to finda a record on my form by
the name of the examinee we are testing. I told it to use the lastname,
firstname, and middlename. I then told it sort the records in ascending
order. The box works fine when there is only one Baker, or Davis but if
there are 2 or more it will only take me to the first one listed. How can I
make it take me to the one I pick?

Thanks in advance for the help
 
C

Chris Reveille

I assume you have a primary key. The combo box should be
set up in the order
PrimaryKeyField
lastname
firstname
middlename
You can hide the PrimaryKeyfield
and sort by lastname, firstname, and middlename

Chris
 
Top