If you don't want to go and fix the data  in the hidden  sheet, you will need
to add edit  or fix functionality to your form. Nicest would be to simply
allow the record to be reopened in the form  and then change the add  to Save
or OK.

I don't know what you mean by "identify" wrong  data. You should be
validating the fields before you store them - that's just normal programming
practice. But what constitutes "wrong data" - anything from simple
misspellings to typing in something associated with a different record by
mistake. No program will be able to catch these - you will need the edit or
fix facility.