Check if record is locked

P

Pip''''n

I have a form that is set to have record level locking. When the form is
opened, some code is run to calculate totals and update fields on the form If
the record is locked the user receives messages such as "can not update
control" which is very mis-informing for the user. If the record that the
form is opened by another user and is locked i would like to display to the
new user that the record is locked rather than receiving these sometimes
indecipherable message that access spits out.
Is there an easy way to do this?

Thanks in advance,

Pip''n
 
Top