I have been using access 2000 for some time now to record my cd collection. The forms were shown in numerical order, using "RecordingID" - AutoNumber (Data Type).
Now the forms are being displayed in a random order. I must have unknowingly clicked on something.
On investigation it appears that the records are being displayed in the order in which the artists were added to the Recording Artist Table.
How do I get back to how it was?
jim scott![]()