Hello, I am a beginner in MS Access.
I create a database with a table of 20 fields, a form with those 20 fields of the table and two buttons "ADD" and "SAVE". I can do the following.
When the form load then the form fields disable to enter any data in any fields. After that I click the "ADD" button to enable all the fields and set focus on "ID" field. Then I can input data in all fields and click "SAVE" button to save the records in database table.
And now my purpose is to check all the fields must be filled otherwise prevent user to insert data in the database table by showing error message and also clear all user form fields.
I want help for doing this.