table sorting problem

[Guest]

I have a table keyed on DiskNum and FileNum, which is sorted ascending. I am
using code to run through each record and populate a new field
(ImageLocation)that I have recently added. My problem is that the table
appears to be sorted correctly when I open and view it, but when I am testing
my code and use a message box to show the file number and disk number, it
appears to be sorting by the new field! (It was working correctly yesterday,
and I have not made any changes since!!)
Can anybody help??!

 

[Rick B]

In general, you should not care how your table is sorted.

You should be working in your forms, queries, and reports. Tables are just
buckets for holding the data. The order is not important in the table.
When you build a form, report, or query, you can define how you want it
sorted.