Change default error message

[WalkieTalkie]

How do I change the default error message that comes up when users try to enter a duplicate primary key? The default error message is "The changes you requested to the table were not sucessful because they would create duplicate values.." blah blah. I want to replace it with something they understand. I've tried putting a message in the form's On Error event but that doesn't stop the default message from appearing. I'd appreciate your help!

 

[PHV]

but that doesn't stop the default message from appearing
Even with the following code ?
Response = acDataErrContinue

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya WalkieTalkie . . .

You can test to see if the new PK exists before saving the value. As an example, try the following in the [blue]Before Update[/blue] event of the PK control. Note: [blue]you![/blue] substitute proper names in [purple]purple[/purple]:

[blue]   Dim Cri As String
   
   Cri = "[[purple][b]PKName[/b][/purple]] = " & Me![purple][b]PKName[/b][/purple]
   
   If IsNull(DLookup("[[purple][b]PKName[/b][/purple]]", "[purple][b]TableName[/b][/purple]", Cri)) Then
      MsgBox "Duplicate PK Exist!"
      Cancel = True
   End If[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[WalkieTalkie]

Thanks, PH & AceMan, both help! Sorry for the slow response - had a bit of R&R over Christmas, New Year etc. Happy New Year to you guys!
Cheers
Miranda