Error Message Trapping

[Guest]

I am developing a form that I need to trap the error message "Index or
Primary Key cannot contain a null value". The error occurs when a field in
entered and then deleted by backspacing or highlighting. Thanks

 

[Allen Browne]

This is an engine-level message, so you can trap it in the Error event of
your form.

The simplest solution is to teach the user to press Esc to undo the entry.
Otherwise they are not allowed out of the field until they provide a valid
value.