how do you display forms numerically using id number

[scottjas]

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

[RuralGuy]

The RecordSource of your form should be a query with an OrderBy Clause.

[ssanfu]

How do I get back to how it was?

jim scott

You might try looking in the menu bar under "Records". If the command "Remove Filter/Sort" is not grayed out, try clicking it.

[accesskid]

If it is the Primary key and the order has been changed, you may try firstly trying to compact and repair your database.

[scottjas]

thanks to all who have replied.
ssanfu - tried your suggestion with no luck
ruralguy - "The RecordSource of your form should be a query with an OrderBy Clause". Sorry my knowkledge is somewhat lacking. i don't know what you mean or how to carryout the suggestion.
accesskid - the primary key has been allocated to RecordingID in the Recordings: Table. How do you compact and repair the database?

[RuralGuy]

Create a query of your table that sorts on the columns you want. Then assign that query as the RecordSource of your form.

[accesskid]

scottjas: simply click onto file on the ribbon and under information there is a choice to select compact and repair, make sure all your recent work is saved before hand so nothing is lost.