Hi,
I have a table of around 1000 rows; patient records. Each row is
individually defined by a Patient ID number which is my primary key.

I have made a simple form to display patient information for the
secretaries working in the office. I would like them to be able to
easily search through all the records using a combo box, that they can
just type in the person's name. I have managed to make it work so far
as when the last name is typed in the, the first person with that last
name comes up (first person being the person with the lowest Patient ID
number).

I would like to be able to alphabetize the combo box list, because now
it's ordered by the Patient ID number, thus the names are nothing but a
jumble in the combo box. I cannot make last names the primary key
because multiple people have the same last name.

How can I easily create a combo box that is alphabetically ordered, can
be typed into, and will display a record on the form when it is clicked
on in the combo box?

I'm a newbie at queries as well.

Thanks all!