Thanks for the reply. Unfortunately with Access you can not really lock
one, and only one, record at a time. The choices are to lock all the
records in a table or a "page" of records when one record is being edited.
Neither of those choices is viable for our application. We have situations
where multiple users may be accessing and updating records in the same table
at the same time and we could make their lives miserable (not to mention our
support staff) implementing any of the Access forms lock strategies.
>Why not implement a recordlocking strategy. If records are locked when
>edited you do not run into this problem.
>The recordlocking can be set from a forms .recordlock property.