Recent content by DavidPaul

Thanks to everyone for your assistance. I finally solved the problem by trapping the Access error I did not want and then resuming the code. I also disabled the 'X' control on the form so that users can only close the form using my own button.

I tried your suggestion but I get the same results. It doesn't seem to matter what I try I still end up getting the annoying Access messages! I've got to the point where I don't care how I do it, I just want to be able to tell the users in a controlled and friendly way which fields are wrong...

Stephen thanks for the suggestion, but I have already set the required fields to Yes in the table design. All I am trying to do is to ensure that before a form is closed all required data is present and its integrity is maintained! (Note that I have developed a handful of Access databases for...

I’m hoping someone can help with this problem which I have been struggling with for a few days now. So much so that I have created a small database to specifically try to resole the problem! My problem concerns the use of validation for all fields on a form before I save it. Over the last...