Sort records in a list box, drop-down list box, or combo box

If you use a wizard to create the list box, drop-down list box, or combo box, Microsoft Access automatically sorts the rows that make up the list by the first visible column. If you want to specify a different sort order, or if you're using a saved query as the row source for the list box, drop-down list box, or combo box, you can use this procedure.

Note   Wizards are not available in a stand-alone data access page, or when you point a data access page to a database other than the one currently open. In this case, you will have to create a list box or drop-down list box on your own.

1. Open the form in Design view or the data access page in Design view.
   
   
2. Make sure that the list box, drop-down list box, or combo box is selected, and then click Properties on the toolbar to open the property sheet for the control.
   
   
3. Do one of the following:
   • To change the sort order of a control on a form, in the RowSource property box, click the Build button to open the Query Builder or SQL Statement Builder.
     
     
   • To change the sort order of a control on a data access page, create a query with the sort order you want, and then in the data access page ListRowSource property box, select the query from the list.
4. Specify the sort order.

   How?