Make sub forms required before saving?

  • Thread starter Thread starter Ultraviolet47
  • Start date Start date
U

Ultraviolet47

Hi everyone,

I have a form with two sub forms on.

At present, you can save the data entry form without altering the
contents of the two subforms.

However, these subforms contain data needed for reports, etc, so MUST
be changed-is there anyway I can make it a requirment for the sub
forms to be altered before it is saved-sort of like required fields,
only with subforms? Stupid question? Any way around it?

Thanks guys
 
Ultraviolet47 said:
Hi everyone,

I have a form with two sub forms on.

At present, you can save the data entry form without altering the
contents of the two subforms.

However, these subforms contain data needed for reports, etc, so MUST
be changed-is there anyway I can make it a requirment for the sub
forms to be altered before it is saved-sort of like required fields,
only with subforms? Stupid question? Any way around it?

Thanks guys
Click to expand...

Not really. The parent is saved as soon as focus is moved to a subform so that
means that the parent record must be "savable" before a child record is created.

You can run code that checks for any parent records having zero child records
and alert the user.
 
Back
Top