I am struggling with a data entry form, I have created in Access.
There are about 10 fields on the form that are required, they range from combo boxes, text fields and memo fields. The rest is not required information. In the table i have all of the feilds marked as required. Right now the error message is pretty generic, saying "The table doesn't allow for a null value" I want the error message to tell me which feild it is not letting me submit? What is the best way to do this? Through code? In the table? How can I get this set-up?