Saving a Sort Order

  • Thread starter Thread starter Gary Samuels
  • Start date Start date
G

Gary Samuels

Any one know why my Form (based on a query) is saving the
sort order every time I close the database?

I thought a database would never save a sort or filter?

I can sort by any field in ascending or descending order
and if I close the database the sort order is still there
next time I open the database.
 
-----Original Message-----
Any one know why my Form (based on a query) is saving the
sort order every time I close the database?

I thought a database would never save a sort or filter?

I can sort by any field in ascending or descending order
and if I close the database the sort order is still there
next time I open the database.

.
the sort order on a query is saved with the query.
Click to expand...
If you open your database without the query the sort order
is based on the Key and indexes. If you resort it using
the A to Z or Z to A then it should ask you if you want to
save the design of the table. If you press yes then the
sort will save. If it does not ask you if you want to save
the design then your setwarning is set to no. To correct
this create a macro that changes the setwarning to yes.
 
Exactly,
If I open a table and sort it, Access will ask me if I
want to save before closing.

If I open a Form List based on a Query and the Query has
a field set to sort, it should sort the list according to
that field. Instead the List is sorted in the order it
was last closed. And when you sort the list it never ask
if you want to save the list before closing.

What's up what that?
 
Back
Top