I have created a form that populates a report from values in a listbox. When values are added to the listbox (from another listbox), a number is dynamically assigned to the entry to record the order - so the records are viewed on the report in the order in which the user places them in the form listbox.
This listbox (that populates the report) will usually hold no less than 50 records. The user wanted to create the custom sort (where he identifies the listbox order) because he wants to have multiple sections separate these records within the report.
So...my question!
I need to figure out a way that my user can dynamically create some type of break or insert a 'bookmark' so that when the report runs, the records will be separated (can just be a line break, but preferably an actual title) based on these inserts.
My best thought on a solution is to have a listbox (value-based) that the user can insert into the listbox that populates the report. I think this would work but it just seems complex and dirty. So, I was hoping to get ideas on better, cleaner solution.
If I have explained this poorly, I would be happy to expound at your request.
I hope you can help and thank you, in advance.
This listbox (that populates the report) will usually hold no less than 50 records. The user wanted to create the custom sort (where he identifies the listbox order) because he wants to have multiple sections separate these records within the report.
So...my question!
I need to figure out a way that my user can dynamically create some type of break or insert a 'bookmark' so that when the report runs, the records will be separated (can just be a line break, but preferably an actual title) based on these inserts.
My best thought on a solution is to have a listbox (value-based) that the user can insert into the listbox that populates the report. I think this would work but it just seems complex and dirty. So, I was hoping to get ideas on better, cleaner solution.
If I have explained this poorly, I would be happy to expound at your request.
I hope you can help and thank you, in advance.