Add new comment

The problem is very obvious. You did not add error trapping or form validation.

In the cmdSave_Click procedure you could add a code below to validate a form:

If txtNo.Text = "" Then
     Msgbox "Please enter a Number."
 
     Exit Sub
End If
 
If txtName.Text = "" Then
     Msgbox "Please enter Name."
 
     Exit Sub
End If

etc...

You may try adding error handling also:

On Error GoTo err_Handling

err_Handling:
Msgbox err.description