@kscholiadis as a matter of fact, I almost never submit forms via a dataset (only with a direct inserts), so I can only tell you, what I 'd expect it to do, and you’ll have to try it.
I think that when you click “Submit”, it validates the entire form, and if any of the required fields is not valid, it won’t let you submit the form at all and will make the invalid input element borders red.
(P.S, if you have set some of your inputs to be ‘not required’, it won’t validates them.)