Detect locked record with VBA

D

Damir Matijevic

I have simple problem, but (for me) it's hard to crack. My form is bound,
using pessimistic locking (Form properties - Record Locks: Edited Record).
How can I found out if another network user locks current record? OK, it's
visible on Record selector, but how detect this with VBA, so I can perform
some additional operations (lock datasheet subform with related records,
give user text message that current record is locked)? Or, is there any
other way to lock all related records in datasheet subform when current
record is locked? (maybe I'm just to blind to see...)

I have A2K.

Thanks a lot,
Damir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Locking Multiuser 1
Error "Field can not be updated" when entering data in a subform 3
Populate main form from subform record 0
Lock a form 3
Form will not allow data entry - currently locked error 0
Locking issue after Database Split into FE/BE (Access 2000) 1
Lock only updated record 6
Hide/Skip Records that have "Edited Records" Record Lock 2

Top