I have created a pop-up form that allows users to select multiple values (Case IDs) and publish a report based on those selected values. This works well, but there is one further need...
Within the listbox which holds the selected records, I would like to somehow insert predetermined values to serve as dividers. So, when the user wants to publish the report the data is correctly separated between the dividers.
An example (to clarify):
4 records
How it looks now -
TC1
TC2
TC3
TC4
How I want it to look -
Case section 1
TC1
TC2
Case section 2
TC3
Case section 3
TC4
I am unsure both on how to add these 'dividers' into the listbox and how to have code in the report understand what is happening and separate the data based upon these values.
Hopefully, I have explained this sufficiently but if not, please let me know. I am stumped and would appreciate any assistance.
Thanks.
Within the listbox which holds the selected records, I would like to somehow insert predetermined values to serve as dividers. So, when the user wants to publish the report the data is correctly separated between the dividers.
An example (to clarify):
4 records
How it looks now -
TC1
TC2
TC3
TC4
How I want it to look -
Case section 1
TC1
TC2
Case section 2
TC3
Case section 3
TC4
I am unsure both on how to add these 'dividers' into the listbox and how to have code in the report understand what is happening and separate the data based upon these values.
Hopefully, I have explained this sufficiently but if not, please let me know. I am stumped and would appreciate any assistance.
Thanks.