Order of records in form has changed!
Posted on 2004-11-23
I have a form, based on a table to which I have recently migrated a new set of records. At first, everything looked fine, but I recently when I opened the form at home , after working on the application in work, I noticed that the form starts at record number 25 (Record PK, Number datatype). Record number 1 is now the 119th record (according the navigation buttons). What the heck have I done? When I look a the table in datasheet view, it lists in the correct order. The only index I have in there is the PK!