Record lock message

[poliv]

I have my database file in an NT server, and when a user try to modify a record that is locked by another user, I want to display a personalized message to that user, and not the default message.

Thanks.

 

[Rohdem]

If you can find out the error number, you can trap it using the 'on error' event of the form:

This example traps the error that occurs when you enter a duplicate primary key value:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
If (DataErr = 3022) Then
MsgBox "You have entered a duplicate primary key value"
Response = acDataErrContinue
End If
End Sub
Mike Rohde
rohdem@marshallengines.com