Access 2000 form using SQL Server

[lestersal]

Hi,

When I click on the sort button on an Access 2000 form tied to a SQL Server
recordset and then try to enter data with the Sort/Filter on, the form jumps
around and tries to go back to the sort order of the underlying recordset,
which is a SQL Server stored procedure.

Can I code the form to hold the sort while I am entering data into it? Is
this a glitch is Access 2000 which has been fixed in 2002 or 2003?

Thanks,
Alistair