Changing "Index or Primary Key cannot contain a null value" message

Hi everyone,

I have a form with several fields. One represents the primary key. If you
leave it blank and try to save the record, the forms displays the following
error message - "Index or Primary Key cannot contain a null value". I
understand why it is doing this, but I'm wondering if I can program a
friendlier message. Any help would be great.

Many Thanks!

Check out the Form_Error event.

HTH,
TC


"JBrow" <j@jdp.coj> wrote in message
news:5Hgpb.65196$mZ5.390750@attbi_s54...[color=blue]
> Hi everyone,
>
> I have a form with several fields. One represents the primary key. If[/color]
you[color=blue]
> leave it blank and try to save the record, the forms displays the[/color]
following[color=blue]
> error message - "Index or Primary Key cannot contain a null value". I
> understand why it is doing this, but I'm wondering if I can program a
> friendlier message. Any help would be great.
>
> Many Thanks!
>
>[/color]