I've updated from Office Pro for XP to Office 2007, opened my old database and saved in new format.
Records saved as 'Ref' which is the primary key. When opening a form in 2002 to display data, the first record displayed was 1 followed by 2 etc. Buttons would select 'First' Last' 'Next' 'Previous.'
In 2007 the same happens, except if a new record is created and the form opened, that new record is displayed first, not record 1.
So, in Access 2002 if records were numbered 1 to 20 they would be displayed automatically 1, 2, 3 etc., but now with say 2 new records created i.e. 1 - 22
the display order is 21, 22, 1, 2, 3 etc.
How do I rectify this to display records in Ref order 1 to 22?
Hope someone can help. Regards - John