Sorting records in table linked to combo box

[Guest]

First, I am new to Access. The problem I am having is that I am trying to
sort the records, A-Z, in a pull down menu.

I created a form. One of the boxes is a combo box. Here, the data user
should select the file format from the drop down list. The data within the
list comes from an existing table. The file formats, when listed in the drop
down menu, appear in the order they were entered in the table. There is no
sense to them, i.e. ".shp, .jpg, .avl". I would rather sort the file formats,
i.e. ".avl, .jpg, .shp". How can I sort my records in the form view?

 

[John Vinson]

How can I sort my records in the form view?

Base the Form (or the Combo) on a Query with the field sorted as you
want it. Tables are not in any particular order - they're like a heap
of records.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps