Combo box issues

[Sue]

I have designed some forms that use a combo box to pull from a table. The
table has a list of ~ 50 choices, and despite alphebetizing the source table,
I cannot get the list in the combo box to populate alphabetically. Even if I
blow up the forms & start from scratch, I can't get the full list to display
in alphabetical order.

What am I doing wrong?

Thanks!

 

[Sue]

I tried that but wound up with a different issue this time. But first, If I
try to develop queries for alphabetizing all the combo boxes I may design
over time, it seems to me that I'll be loading up the database with objects
that would more logically be handled without this additional step. But maybe
I'm slow....

At any rate, when I designed the query you suggested, rather than the
alphabetized text then showing in my combo box, I see the primary key (not
the text) in the combo box. In the query I've included the text I want to
display & sorted it alphabetically, and included the primary key but
unchecked the "show" box before saving. The query then shows what I want to
see, but when I insert the combo box into my field, I see the primary key
displayed. If I go back to the underlying query you suggested, I no longer
see the primary key field when I look into design view.

What the heck???

 

[Sue]

Mark - I've also tried NOT including the primary field in the underlying
query at all (rather than simply not showing it) but still run into problems.

After selecting the query as source using the wizard & choosing the field(s)
to display, the next this the wizard to is to say that I can either store a
value from that row in the database or use the value later to perform an
action... at which point I'm asked to choose a field that uniquely
identifies the row. I choose the text I've alphabetized (which IS unique),
then am asked to select either "remember the value for later use" or "store
the value in this field". If I store the value as a field, I see the primary
key rather than the text. If I remember the value for later use, I see
nothing at all.

Waah.

Help, please? I clearly don't understand.

The SQL for the query is:

SELECT tblDiagnosticCodes.Diagnosis, tblDiagnosticCodes.ICD9Code
FROM tblDiagnosticCodes
ORDER BY tblDiagnosticCodes.Diagnosis;

 

[Sue]

Marvellous!
Thank you so much!