Index cannot contain null value error

[katoc]

Hello.

I have a form for data entry. When a user hits 'new' but then decides to close the form before any data entry is done, I get the error "Index or Primary key cannot contain a null value". There is one value in the form that is automatically populated in the form_current function. Which property/method do I use to undo any changes when the user closes the form on a new record?

Thanks

 

[PHV]

I'd use the BeforeUpdate event of the form to enforce all the validation rules.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886