Datasheet inside form

[James007]

I have been fighting a problem with sorting the data in a subform that is in a datasheet. It is sorting the data automatically so the entries are not in the original order. Is there a way to disable the feature so that when I put data into the datasheet it will appear in the same order that it was originally.
Hope this makes sense.

Thanks for your help

 

[way2bord]

No. Your data must be sorted by some column. Typically it's the Primary Key AutoNumber field. Text will be alphabetized.

Add a new column, call it sort order and number each item how you want it sorted.

 

[missinglinq]

...Your data must be sorted by some column...

Where did that bit of misinformation come from? Data is only sorted if you tell Access to sort it! As the Blaster has suggested, it could be sorted in the underlying Query, if the Subform is based on a Query. Check the Record Source for the Subform; if it is a SQL Statement, does it include an OrderBy Clause? In the Property - Data Tab, does the OrderBy Property have a Field listed? Lastly, look at the Form_Open and Form_Load events to see if they have any code that is controlling the Order or Filtering/Order of the Form.

Linq ;0)>