I hope that someone will be able to help.
I have a MS Access 2000 form which has the ALLOWADD and ALLOWEDIT set to Yes. It is based on the selected statement "SELECT MYTABLE.* FROM MYTABLE ORDER BY MYID". This application works fine on my computer and on three other computers, however on the client machine it will add, but not edit.
On the microsoft website, they suggest that it is caused by a non updateable recordset. However the select statement is so simple, I can't see why it would not be updatable.
Thanks for you time.