Add data form

[Mish_h]

Hi.
I have a form that is used to add data to a table.
The txt boxes are bound and i have set the form property of data entry to yes. This all works fine
however if i enter a some data into one of the text boxes but then delete it and close the form. it inserts a record full of nulls into my table.
I do not want it to do this.
Does anyone know how i can get round this problem?

Also as far as an command button for the user to click to enter the data. is it just a case of closing the form or does a commit need to take place?

Thanks

 

[Smart]

I would remove the exit button from the form(top right)
And have a button to save the record.
In the buttons on click event prior to the save record command I would validate each field on the form (if it is null or the wrong format display a meaning full error message return focus to the field in error then stop the save process by exiting the code using exit sub)