Table Sorting 1

[mkov]

Is there a way to sort a table that is open in code? I need to be about to sort a table that I have open in code and am not sure how to do it. I am not looking to filter the table, just sort it.

Thanks for your help.

 

[JeremyNYC]

What are you trying to do? Tables do not get saved in any order. If you want to see ordered data, build a query tht sorts the data.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[BNPMike]

You can't change the order of a table in code. I honestly would advise you to first understand why before getting too deep into coding.

 

[mkov]

Thanks JeremyNYC, I was looking a something I wrote over a year ago and never sat back and thought of another way of doing it. I am adding a couple of things to the routine and trying to fine tune it some.