ordering in subforms

[Graham Bucknall]

I have a database with firms and employees. In the header I choose a firm, in the main form the data about the firm is dispalyed and then in the subform I have a list of employees who are part of our project. The trouble is they don't come out in alphabetical order by surname which I need.
There is a table for firms and one for employees and they are linked by a firmid.

I have tried various things but nothing seems to work.

 

[Rich]

Right click on the column and select sort ascending from the pop up menu , click ctrl + S you may have to do it more than once but Access will eventually save the order by on the subform

 

[Graham Bucknall]

I've tried this about 10 times now on the subform (which does come out sorted alphabatically when i just open that). When I open the main form with the subform embedded then it goes back to them appearing unsorted on the subform section!!