sort problem...let me try to explain better

[mitchem1]

The form I am working on has a table for the record source. When I sort on a certain column in the table - no problem. However, when I allow the user to view the form in Datasheet view, the sort options are disabled when this column is selected. Any ideas? Thanks.

 

[Rich]

What do you mean selected, just tab into one field and then sort.
HTH

 

[DonK]

Datasheet view (Sort disabled)

I'm having the same problem while viewing a form in Datasheet view. When I right click the field header, some of the fields allow Sort Ascending and Sort Descending but other fields haing the Sort options disabled.

Has anyone been able to explain the conditions that the cause the Sort option to enable or disabled when in Datasheet view?