Form/subform update dilema

[WC23]

In brief, I have a form with a subform. I need to be able to check that
required fields are entered on the main before update. However, the subform
also has required fields, which can't be entered because the main form
loses focus and triggers the before_update which checks the required
fields.

The user changed requirements for having the subfields entered at the last
minute, so I'd really like to find a reasonably clean solution for this
without a lot of clunky code. Any thoughts?

 

[Allen Browne]

Are the form and subform bound to the same table?

Or to 2 tables with a one-to-many relationship?

 

[WC23]

Are the form and subform bound to the same table?

Or to 2 tables with a one-to-many relationship?

My apologies for the delay in reply. Trouble reading the group.

The subform is a 'many' to the main form's one, different tables.
(Actually, it's 'any' since there can be no entries.)