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
Chris Reveille - 09 Feb 2005 18:26 GMT
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
>-----Original Message-----
>I have used the wizard to set up a combobox to finda a record on my form by
[quoted text clipped - 6 lines]
>Thanks in advance for the help
>.