Maintaining original order in subform

[clending]

I have a subform that is grouped by Item Number and then Room (from a list of detailed work to be done). These groupings work correctly, but then I want the descriptions of the various items within the group to maintain their original order. If I leave then unsorted, they come out in alphabetical order, and the only choices I have if I choose to sort them are ascending or descending. I want neither -- I want them to appear as entered in the table.

ie: Ceiling
Walls
Woodwork
These items .....

Every time I do this, it comes out:
Ceiling
These items ......
Walls
woodwork


Any ideas on how to force the original order they are entered in.

Thanks.
Craig

 

[cmmrfrds]

Does the table have an auto number as the id. An auto number is incremented when a new record is added to the table.

 

[clending]

Thanks much for the rapid response - including an autonumber field did it. Once again, this forum proves invaluable!