In the Access 2013 app I am working on I have the pretty standard main form 'frmDocumentDefinition', subform 'frmDocumentInterestedParties_Sub' set up.
In this case the main form is used to enter specific about a mail merge document to be created. Information such as:
The location and name of the mail merge document
Document type, which is an internal category.
Whether the output of the mail merge should be PDF, Word or both
The subform is where the distribution (who gets this output) is entered. It is a subform because At least one person must be specified in the distribution but there is no limit to how many recipients there can be.
Since I can't force them into the suform, or can I, I want to make sure they entered at least one recipient. This has to be done form the main form.
I've been developing in Access for many years but have not encountered a requirement like this before.
From the main form, how can I check whether at least one entry has been made on the subform?