Hello,
I'm designing a report, that is generated based on a user selection form.
This form is comprised of multiple subforms.
Each subform has categories that may or may not be applicable.
I want to generate a final clean report, that is a formal document, that only shows what is applicable.
I'm relatively new to access and wanted to get feedback on the best way to do this, if anyone could offer a suggestion I'd be extremely grateful.
For example:
Form MAIN has form a and form b.
Form a has 3 categories. Two of these categories have values (Category FormA-1, Category Form A-2). one is null, as it is not applicable. Then imagine a similar scenario for form b.
On the report that is generated, all tied together by a corresponding certificate ID through the main and subforms, I only want it to show exactly what is applicable and nothing more. I primarily want the spacing on the report to be reduced so just making "is visible" via VBA won't help as I need it to shrink to only show relevant data.
Thank you so much for any suggestions.
Respectfully,
Ashley