Show the lock status of a record with VBA

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??? :confused:

Show the lock status of a record with VBA