combo box

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

I have a combo box that is base on a table, on a form.
How do I sort from A-Z in my combo box.

Floyd
 
---------- "Floyd Forbes said:
I have a combo box that is base on a table, on a form.
How do I sort from A-Z in my combo box.
Click to expand...

Floyd,

create a SELECT query based on the table and set the RowSource
property of the combo to the query. When creating the query, set in
the query grid the sorting (3rd grid line) to Up for the field you
wish to have sorted.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 

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

Please Help! 2
cant get cbo to stop outputting key# 0
Access Form - Lock Fields from Editing 0
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Combo Box reduction 0
Automatically generating text entries from combo box 4
1 combo box changes per 2 other combo boxes 3
sort order in combo box 6

Back
Top