Hi

How can I lock the record once I open Edit Form to edit the record? I
already set the pessimistic on the form but the problem
I meet is when first user open the Edit Form but before he does any edit
record action, other user can still edit the record. Therefore,
I wonder how can I lock the record once the Edit Form is open. Thanks.

Hi,


Assign a control bound to a field to itself, that would mark the
record as being dirty ( and in the process of being edited ):

Me.ControlName.Value = Me.ControlName.Value



Hoping it may help,
Vanderghast, Access MVP





"Cheng-Liang Shen" <Cheng-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> How can I lock the record once I open Edit Form to edit the record? I
> already set the pessimistic on the form but the problem
> I meet is when first user open the Edit Form but before he does any edit
> record action, other user can still edit the record. Therefore,
> I wonder how can I lock the record once the Edit Form is open. Thanks.
>
>
>
>