Determine if a record is locked

[Peter Kinross]

There is probably an easy way to do this. Does anyone know how to determine if a record is locked in Access 2003 using VBA?

[johnhutchison]

I have not tried to do this, but looking around I found this

It assumes you are dealing with a form. The code tries to edit the record in the form's recordset. If the record is locked that will generate an error.
So if the error occurs the record is locked. If the error does not.
The code in the link goes on to tell you who has it locked, but you could ignore that bit.

[Peter Kinross]

Thanks John.
That solution seems just the thing. I'll give it a go.
Thanks again.