I'm using VB6 and Access 97 with ADO

I've got a multi user application and I've got a button marked [Edit]. I want to put some kind of trap there so that they cannot edit this record if it is already open, but having no luck, can anyone point me in the right direction.

I've opened the table using Pessimistic Mode

------------------
Thanks in advance for any help provided.