locking a record to edit it.

[diane.fearnley]

I have a form where a user selects a ref number and then another form
opens with this record details showing. The problem is the record does
not lock until the user begins to type an update in one of the boxes.
In the meantime another user can open the same record and begin to
type an update. Only the second users changes are kept and the first
user is told changes not saved. How can I stop this and lock the
record immediately on opening?

 

[Powderfinger]

Do you have "Open Databases Using Record Level Locking" checked? And
"Default Record Locking/Edited Records" check? You'll find these on the
Tools/Options/Advanced dialog box.