Have Form Sort Data Alphabetically

[Karl Burrows]

I created a simple form for a group to track members in their interior
design society. The problem is the data in the table and form is in the
order the data was input. I would like for it to show in alphabetical
order. Is there a simple way to do that? The primary key is just an
autonumber.

Thanks!

 

[Dirk Goldgar]

I created a simple form for a group to track members in their interior
design society. The problem is the data in the table and form is in
the order the data was input. I would like for it to show in
alphabetical order. Is there a simple way to do that? The primary
key is just an autonumber.

Thanks!

Base the form, not on the table itself, but on a query that sorts the
table alphabetically.