Catch a null primary key error

[BobJones]

Hey guys,

Anyone know how to go about catching the "Index or primary key cannot contain a Null value." message box and perhaps showing a custom message instead?

Thanks in advance,
Bob

 

[ansentry]

Put this code in the Before Update envent of your form;

If IsNull(Me.DataID) Or Me.DataID = "" Then
    MsgBox "You have not entered a Data ID", vbInformation, "No Primary Key"
    Cancel = True
    Me.DataID.SetFocus
End If

DataID is the primary key, set to Number /Required.

 

[BobJones]

thx very much for your help, it worked great.