Showing Records in a subform in a specific Order

[Jasonm]

Hi,

I am trying to always have my subform records sorted in ascending order. It
seems to work for the first record, but when moving to the second record in
the data set the subform order is no longer ascending.

Does anyone have any ideas? I am showing the subform in datasheet view and
not accessing it through a query (right to the table) maybe this is the
problem? There are many records for each record on the main form.

Any assistance would be appreciated. TIA

Jason M

 

[John Vinson]

Does anyone have any ideas? I am showing the subform in datasheet view and
not accessing it through a query (right to the table) maybe this is the
problem? There are many records for each record on the main form.

Yes, that's the problem. Access will display records from a Table in
whatever order the query optimizer finds most convenient.

Base the Subform on a Query of your table, sorted however you like.
The Query will still be updateable provided you don't do anything
outre like making it a Totals query or joining four or five tables
together.

John W. Vinson[MVP]

 

[Jasonm]

John, I know that it is late, but thanks very much for your reply. Work is
very hectic sometimes and I tend to forget that I have requests for help
posted on these news groups. I appreciate all your help and the help of
those who post in these groups.

I will give your solution a try.

Thanks again, Jason