This is a problem that's bugged me for ages and hopefully you can help me. I have an Access form being fed by a SQL Stored procedure that cuts data down to a specified manager. One of the fields is a name which I'd like to be able to sort ( easy ) which can then be amended. The problem is, everytime You go to change the field it resorts back to default. How do I stop it from doing this? I don't want the form to do anything sorting wise. Using access 2000.