F Floyd Forbes Mar 29, 2004 #1 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
E Emilia Maxim Mar 30, 2004 #3 ---------- "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
---------- "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