Show who has a record locked??

[stephen3]

First of all hi everyone, im lookin for some advice

i have database setup with record level locking for multiple users (havent decided weather its should be optimstic or pesimistic yet)

however either way i set this there is no idication that the record is opened/locked by another user is there an easy way to say pop up a msgbox when a user enters a record to say this is in use/locked and show who by using the username?

Thanks

 

[freakazeud]

Hi,
check this discussion:
isLocked
and check:
orders sample db
quote: There are also several useful functions located in the UtilityFunctions module, such as the IsLocked function which determines whether the current record is locked.
end quote!
HTH
Good luck