Make sub forms required before saving?

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
 
R

Rick Brandt

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top