[AccessD] A2003: The Changes you requested blah blah blah

Darren:
The number you seek is not an "Err" number but a "DataErr" ...
In this case, I think its 3022 ...
Drop this code into your form, you'll see how to make Access do whatever
you want in each situation.

Hth
Steve

Private Sub Form_Error(DataErr As Integer, Response As Integer)

Select Case DataErr
Case 0
Case Else
    MsgBox "Data error number is: " & DataErr
    Response = 0 '  <--- suppresses Access msg box
    
End Select
End Sub

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren Dick
Sent: Thursday, May 05, 2005 7:54 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] A2003: The Changes you requested blah blah blah


Hi Guys
What is the error number that spits up when users create a duplicate
value they shouldn't have

You know the one ...
"The changes you have requested were not successful because They would
create duplicate values in the blah blah blah"

Also where do I trap this, where do I put the 
if err.number1234 routine?


Many thanks

Darren

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com