Sub form sorting

[radmanmm]

Hello All,

I have an issue that is driving me crazy. I have a subform on a form that acts as the detail for a list. It is set to a table not a query. For some reason the individual items are being ordered alphabetically. I have no order by clause, no order by property set. I cannot figure it out. I want the items in the sub form to be loaded as they were inserted into the database.

Any help would be greatly appreciated.

Thanks.

 

[WayneRyan]

rad,

When retrieving rows from either a table or query without an
Order By clause results in no guaranteed order of the rows.

If you want the records displayed chronologically, you'll have
to add a date/time field, populate it with Now(), and specify
it in the Order By clause.

Wayne

 

[boblarson]

For a more detailed explanation, check out this post
http://www.access-programmers.co.uk/forums/showthread.php?t=121558
and go to the bottom where you will find the post by The_Doc_Man, who is very good at explaining this.

 

[radmanmm]

Thanks guys,

Yes I am familiar with the idea of databases using set theory, but I don't use access a lot and wasn't sure how it was implemented. The perception that the values seem to be alphabetical was very confusing. I would probably see it all change with a compact operation.

Thanks for the help this board has always be very quick with accurate answers, you guys are great.