Intrinsic Error message in Access97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a form with subforms. The table the main form is based on
requires a primary key for a record to be created.

I am getting what seems to be an intrinsic error "Index or primary key can't
contain null value" with the yellow exclaimation point. There is not an
error number listed but if I follow the help command in the dialog box it
indicates the error is MS Jet error 3058.

I have error trapping written in the before_update event for the main form
for error 3058. But I am not trapping the error.

I cannot determine what event is producing the error. I really need to
trap the error and code to cure the problem.

Any assistance in telling me where the error is originating would be greatly
appreciated.

As noted in the subject line the form is in an Access97 mdb file.

Tony
 
I doubt very much that you'd see the error 3058 in the Before_Update event.
It won't be raised until Access actually tries to write to the table (i.e.:
between the Before_Update and After_Update events).

In your Before_Update event, put logic to explicitly check whether any of
the fields in the Index are null.
 
Back
Top