Show the lock status of a record with VBA

[Sue22]

HI,

I have a form and I want show a message on the form when the it is locked as another user is editing the data in a particular record.
I know the record selectors show the records lock status but it a very tiny symbol which will mean nothing to the users of the database and anyway I don't want record selector bar on the form.
Can any one help me with how I would do this???

 

[Solo712]

HI,

I have a form and I want show a message on the form when the it is locked as another user is editing the data in a particular record.
I know the record selectors show the records lock status but it a very tiny symbol which will mean nothing to the users of the database and anyway I don't want record selector bar on the form.
Can any one help me with how I would do this???

Take a look at this to see if this is what you want:

http://etutorials.org/Microsoft+Pro...+Determine+if+a+Record+Is+Locked+and+by+Whom/

Best,
Jiri

 

[Sue22]

That looks a bit complex and does much more than I want
All in need is something on screen that say the record is currently locked (mainly because users don't notice the tiny symbol on the record selector)