Sorting

[Michele Boutwell]

In my design window for a form, the sorting function
is "grayed out" - it won't let me sort ascending or
descending. In the table, the field is sorted, but when I
open the form window, it is scrambled.
????

 

[John Vinson]

In my design window for a form, the sorting function
is "grayed out" - it won't let me sort ascending or
descending. In the table, the field is sorted, but when I
open the form window, it is scrambled.
????

A Table IS NOT SORTED - ever.

A Table is an unordered "bag" of data; there is no usable "first
record" or "last record".

I'd suggest that you base your Form on a Query sorting the data in the
desired manner.