Validating SubForm Data

Validating SubForm Data

Hi there

I have a Parent form "Bookings" - fields include Name, Company, Email, Phone

I have a Subform "Booking Detail" (field name Booking Details).

I have code on the "Add Row" to populate fields on the subform - effectively transferring the parent fields to the subform.

The problem with this approach is if a user adds a row to the subform BEFORE filling in the parent form, the details don't transfer down.

The other scenario is where they enter the parent form fields, add a row/s, and then before submitting they edit the parent form details.

What is the best way to make sure that regardless of what order things are entered, the fields in the subform are updated correctly before the form is submitted?

Cheers
Aaron