Remove Filter and then sort by field

[loopa1]

Hi all.
Ok...I've been lazy and I've been caught out!

I copied a form to use as another albeit after 'tweaking' it. It has a search box which is used to filter the records and show them in a split form and also has a buttom to remove the filter and show all records. However, when I click this, all the records are shown but they are sorted by the field I don't want to sort by - how do I change which field to sort the split form by after clearning the filter.

Before any filter has been applied, the split form is ordered in the correct way - by ID which is a hidden field.


I'm using Access 2010 - although I've just realised I'm going to have to change these to sub-forms as my end-user will be using A2003...but that can wait until another day!

Thanks.

 

[loopa1]

Ok...spotted that the original form was based on a query which had sorted on a particular field.

So I created another one for my copied form (it was based on a table and not a query) and sorted in that and now it looks fine after removing the query.

Still not sure why it would default to the 3rd field in the table before making the above change.