Finding a record on a from with a combobox

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

Guest

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