How Do I Validate Controls in an Object Group on Form Submission?

Answer

Create an invisible reference label as the last control for the object group and in that control, work out if the line is valid or not.

Create another control as the last on the form to loop though the object group and check the invisible label to determine if the row is valid or not.

If valid, then return blank to the screen, if not valid then return an error message to the screen.

In the trigger check that control:

• If it is blank proceed as normal
• If it is not blank then set the error message