Edited Record Lock

[Doug]

If I have a form in a multi-user environment with the Record Lock set to
Edited Record can I set my own message (rather than the standard "Read Only"
message) for a user if they open a form that another user has open?

 

[Darrin]

Go into the VB code MsgBox "what ever you want it to say" place this in a if
statement that checks to see if the record is locked.

 

[Doug]

Thanks. What does the If statement look like?