No Warning when save fails

[dkaplan]

An Access 2000 database has suddenly stopped displaying a warning when a user fails to fill in a required field. I tried running compact and repair, but it did not solve the problem. As far as I know, there is no code, or macros turning the warnings off. I even tried setting them on with a command button, but that did not work.

Any ideas?

 

[CTOROCK]

I get that problem too, so I make sure there is data in the fields that I want. Use the isNull and Len functions to determine there is data there when they hit the Save button

if IsNull(YourControl) then
msgbox "Hey enter the deptartment name"
Exit Sub

and/or

if Len(YourControl) = false
msgbox "Hey enter the deptartment name"
Exit Sub

 

[dkaplan]

Thanks, ctorock.

In this case, I managed to solve the problem by removing the offending subform. I had originally cloned this from elsewhere and I suspect that one or more of the error handlers was still pointing to the original location. Nice theory, but I never found the smoking gun.

Dennis