I have a database created in Microsoft Access 2007. We have a form we use as the front interface and require people to fill out the fields within the form. However, not everyone fills out the form properly. Therfore, I wanted to make all the fields required and if they leave a certain field, I wanted Access to display the reason for not submitting the form. In other words, "Cannot complete because Last Name field is Blank"
However when I turned on the make field required option thru the table - design view, I received an error message of data integrity rules. I save the database and it appears to fuction worse than it did before.
How can I make the fields required and prompt user with the appropriate message if left blank ?