sort order ans unhide columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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]
 
Back
Top