Need to check if a record is locked in onCurrent()

[martinjsteven]

Help !

I need to display on a form whether the record you have moved to is locked by another user. I have "edited record" (pessimistic) locking on the form. Obviously you'd know it was locked because you wouldn't be able to edit any fields on the form, but the users of the database don't seem to grasp this concept. I therefore need to display a message that the record is locked on screen, so need to check in the onCurrent() event if this is the case, then display LOCKED if it is, and EDITABLE if it isn't.

Please help, my users are doing my head in !

Thanks

Martin