I have a form with two command buttons: Undo and Exit.
This form has several NOT NULL fields. When user leaves one of those fields blank and try to undo or exit the form, msg "Null value is not allowed" keep poping out and does not allow user to back out and start over again.
Anyone knows the VBA codes behind the Exit_Click() and Undo_Click() sub to completely ignore the constrains of and fields and just allow user to get out!
Thanks a lot!!!!
This form has several NOT NULL fields. When user leaves one of those fields blank and try to undo or exit the form, msg "Null value is not allowed" keep poping out and does not allow user to back out and start over again.
Anyone knows the VBA codes behind the Exit_Click() and Undo_Click() sub to completely ignore the constrains of and fields and just allow user to get out!
Thanks a lot!!!!