I could not get, what do you mean by 'locking' a record. I have used Edit to change the current recordset but i am sorry, could not get your problem.