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.
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.