How do you know if a record is locked?

[Jedi420]

In Access 2000, how would one go about (through code) finding out that the record they are on is currently locked so that I can show my user some kind of msg box to let them know that trying to edit the form is useless at the current moment?? And also, how (throug code) would I find out that the lock is gone? Any help would be greatly appreciated.

-Jedi420

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[HomeALone]

To find out when the record is lock or gone, at the form level

Put this in the on_current event of the form

If Me.AllowEdits = True Then
msgbox "current record is editable"
Else
msgbox "trying to edit this record is useless at the current moment "
End If