record order field function , like tab order function

[Guest]

i have a table which needs to be ket in a sort order. an order which needs to
change relatively like the function of setting a tab order...ie moving
records up and down the order in a datasheet kind of interface.
i am currently setting the field 'sort' value manually but as there are
getting more records this becomes more difficult. any ideas of writting code
to automatically set the field value as i move it up the order.
thought of setting a record's sort value to 1 then somehow setting all other
field values of 'sort' +1 relative to that but cant work out how to...any
ideas pls...answers need to be relatively 'simple' as i am a basic level
programmer.

 

[Guest]

Index your data table (recordset) on the field you want the records sorted
by. They will then be displayed in index value order.

If you're "programming" and need to get the records in that order, make sure
you set the recset.index = "IndexName" for the Index you need to be using.