Setup combo box Alphabetically

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

How do I tell a combo box to alphabetize the data it looks up? For instance, my combo box looks up book titles. In the table that the combo box "looksup" the data is not in alphabetical order because I do not enter or read books alphabetically. So, how do I get a combo box to list those titles it looks up alphabetically?

Thanks
Scott
 
Dear Scott:

You could use a query as the row source of the combobox. The query, which is
based on the "looksup" table, can be used to apply alphabetical order.

HTH
Fred Boer

How do I tell a combo box to alphabetize the data it looks up? For
instance, my combo box looks up book titles. In the table that the combo
box "looksup" the data is not in alphabetical order because I do not enter
or read books alphabetically. So, how do I get a combo box to list those
titles it looks up alphabetically?

Thanks
Scott
 
That worked! Thanks! I guess I was just too dense to think of that on my own...ha!!

Dear Scott:

You could use a query as the row source of the combobox. The query, which is
based on the "looksup" table, can be used to apply alphabetical order.

HTH
Fred Boer

How do I tell a combo box to alphabetize the data it looks up? For
instance, my combo box looks up book titles. In the table that the combo
box "looksup" the data is not in alphabetical order because I do not enter
or read books alphabetically. So, how do I get a combo box to list those
titles it looks up alphabetically?

Thanks
Scott
 
Well, if its any comfort, I'm just as dense as you - someone in one of these
newsgroups answered this same question for me when I began working with
Access...

Cheers!
Fred

That worked! Thanks! I guess I was just too dense to think of that on my
own...ha!!

Dear Scott:

You could use a query as the row source of the combobox. The query, which is
based on the "looksup" table, can be used to apply alphabetical order.

HTH
Fred Boer

How do I tell a combo box to alphabetize the data it looks up? For
instance, my combo box looks up book titles. In the table that the combo
box "looksup" the data is not in alphabetical order because I do not enter
or read books alphabetically. So, how do I get a combo box to list those
titles it looks up alphabetically?

Thanks
Scott
 
Back
Top