Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Intersting complication...insert breaks

Status
Not open for further replies.

NRK

Technical User
Feb 13, 2002
116
US
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.

 
I have yet to find a solution to this issue. Does anyone have any advice or thoughts to get me started??

Would appreciate feedback.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top