I have an input form that users can go and select data from a combo box and 2 fields where they can input data.
The problem I am having is that sometimes when users open the form and to enter data they click on the combo box and make their selection and then decides that they do not want to enter the data and clear it out. Access creates a record even though there is no data and I get these empty records in the database.
I have tried using the "required" property in the table, but that even creates more problems for the users, because when they clear it out, and try to do something else - Access error message keeps telling them that they must enter something in the field, and they are unable do anything else unless they enter data in the field.
Is there a way to set it so that it doesn't create a record if there is no data in the field and without having the error message of "required data" popping up?
Any help would greatly be appreciated.
The problem I am having is that sometimes when users open the form and to enter data they click on the combo box and make their selection and then decides that they do not want to enter the data and clear it out. Access creates a record even though there is no data and I get these empty records in the database.
I have tried using the "required" property in the table, but that even creates more problems for the users, because when they clear it out, and try to do something else - Access error message keeps telling them that they must enter something in the field, and they are unable do anything else unless they enter data in the field.
Is there a way to set it so that it doesn't create a record if there is no data in the field and without having the error message of "required data" popping up?
Any help would greatly be appreciated.