I get this error whenever I update a form. 

Index or primary key cannot contain a null value 
What event procedure should I use to attach an error trap add my own 
custom message.?

If it is a bound form use the Form_BeforeUpdate event and in the event do

Cancel = True

in addition to giving the user an error message.  This will prevent the from
from trying to update the table.  You should probably SetFocus to the
control that needs to have the non Null data.

|-----Original Message-----
|From: Howard Stone [mailto:ququmber@h...]
|Sent: Tuesday, April 30, 2002 3:20 AM
|To: Access
|Subject: [access] custom error messagr
|
|
|
|I get this error whenever I update a form.
|
|Index or primary key cannot contain a null value
|What event procedure should I use to attach an error trap add my own
|custom message.?
|
|
|
|
|
|
|
|