sort order ans unhide columns

[Guest]

I have a subform in datasheet view that keeps getting altered by users. Is
there a way to maintain a specific sort order and also lock the columns so
that they cannot be hidden?

Thank you!

 

[John Vinson]

I have a subform in datasheet view that keeps getting altered by users. Is
there a way to maintain a specific sort order and also lock the columns so
that they cannot be hidden?

Thank you!

Difficult, with a datasheet.

I'd suggest using a Continuous Form instead. This gives you, not the
users, control over the arrangement of controls ("columns"). You can
also base the Form on a sorted Query.

John W. Vinson[MVP]