Complication on creating report from form

[NRK]

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.

 

[NRK]

Does anyone have any idea on how to do this? I am stuck and have made no progress!

Thank you, in advance.

 

[LittleSmudge]

You seem to be saying that the list box contains the text entry to go to the form and a number field as well

Then how about adding a third field that can be either "Data" or "Header"

Then in the Report when you get to a "Header" in field3 you insert a Heading separator that contains the text from the field2 in the listbox


G LS

 

[NRK]

LittleSmudge
Thanks for answering my Thread!

That is a great idea - my only issue would be how to integrate Data and Header records together in the listbox.

The listbox is populated on a selection in a combo box. So, I am unsure how to include the "Header" records in the listbox unless I, somehow, have those as default records regardless of the selection in the combo box.

Let me know what you think...

 

[LittleSmudge]

Have a tickbox or some other display that say " The entry you are about to place in the list box will be Data / Header

then in the code that currently updates the storage listbox and adds the number, get it to take the value in the tickbox that said "Header" or "Data" and add that to the third field.




G LS

 

[NRK]

My apologies - I do not mean to be unclear about my concern.

I have a listbox that holds 27 categories. I currently have 1344 records in my database and these can all be filtered by these categories.

The process to populate this form is as follows:
Choose Category (ex: ACL)
Choose record(s) from Listbox #1 (four records associated with ACL - user chooses 1, 3, and 4)
Move selected records to Listbox #2 (user clicks Move, which moves 3 selected records in Listbox #1 to Listbox #2)

So, my issue is that I will never know which records will be in Listbox #1 as these are determined by the Category selection (in the combo box). Would there be some way to insert these "Header" fields into listbox #1 and have them as default or static values in that listbox?

Please let me know what you think...

Thanks!