Finding a record on a from with a combobox

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top