Disable Sort Order Change in table

[yokleyb]

This is probably pretty easy, but I'm unable to figure it out.
We have a few users that sort the table based on whatever criteria they need, but when they close the table it asks if they want to save changes (the sort order). Of course they continually hit yes. Then the next user to use the table gets confused.

Any good news?

 

[JeremyNYC]

Nope. Your users shouldn't be touching the tables or queries directly. Set up forms that allow the users to do what they need. You can set the sort order on a form (via the query on which it's based) so that it's the same every time it's opened. You cannot do that with a table.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[yokleyb]

Thanks for confirming what I pretty much figured out.

Checking out the site now...