Setup combo box Alphabetically

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
 
F

Fred Boer

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
 
S

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
 
F

Fred Boer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A combo box of countries' name with USA and Canada at the top 2 1
Resort a table after update 4
Update combo box 2
Combo Box not showing old records 7
A-Z Sorting Combo 2
Bonkers over a combo box` 13
synchronized Combo Boxes in subforms 2
synchronize combo boxes 1

Top