Record Search through Combo Box problem

[mf193]

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!

[Jana]

MF:

In the design of your form, go to the Properties of your ComboBox. On
the Data tab, click in the Row Source field. You should see a button
with 3 dots on it to the right of the Row Source. Click that, which
takes you to the query for your ComboBox. In your PatientName column,
change the Sort to Ascending. Then close the query and click Yes to
update the property. That should do it!

HTH,
Jana
mf193 wrote:

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!

[mf193]

WOW...thank you!!! Worked perfectly. I feel pretty stupid, I was
messing with this for hours trying to write sortable queries. Thanks so
much Jana.

On Jan 5, 2:59 pm, "Jana" <[e-mail]:

MF:

In the design of your form, go to the Properties of your ComboBox. On
the Data tab, click in the Row Source field. You should see a button
with 3 dots on it to the right of the Row Source. Click that, which
takes you to the query for your ComboBox. In your PatientName column,
change the Sort to Ascending. Then close the query and click Yes to
update the property. That should do it!

HTH,
Jana

mf193 wrote:

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!

[Jana]

LOL No problem. Glad it worked for ya!

Jana

mf193 wrote:

WOW...thank you!!! Worked perfectly. I feel pretty stupid, I was
messing with this for hours trying to write sortable queries. Thanks so
much Jana.

On Jan 5, 2:59 pm, "Jana" <[e-mail]:

MF:

In the design of your form, go to the Properties of your ComboBox. On
the Data tab, click in the Row Source field. You should see a button
with 3 dots on it to the right of the Row Source. Click that, which
takes you to the query for your ComboBox. In your PatientName column,
change the Sort to Ascending. Then close the query and click Yes to
update the property. That should do it!

HTH,
Jana

mf193 wrote:

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!