Ok, I've come to the conclusion that there must not be a way to print values in my listbox in a report. I have a listbox that is filtered/populated depending on what letters I type in textbox (eg. find all entrie starting with "tri...") For each entry you can double click to open a form that lets you views the details for that entry. Now I want to print this list. I was thinking I would need some sort of loop??? All I want is to create a printout for the list generated, but I can't seem to find an answer. Maybe I should go about this a completely different way? Suggestions?
You can do it only if you can match the Reports record source to the listboxes row source. If you use Visual Basic to do all of your SQL you can then apply it to your report. It isn't that hard if you feel comfortable with Visual Basic.
This somewhat follows what Kal said. If you can find a way to mark the records that are put in your list box as having been selected then you can base a report on a query that gets those selected records. Given that I don't know exactly how you filter the info for the list box, I can't offer any specifics. Hope this helps.
strSQL = strSQL & "ORDER BY Files.[Mill Location]"
So when the user enters a text the listbox is filled. How do I transfer this info to a report? I don't want to have to select each item in the list because it is not practical so I would assume I could use some sort of loop?
Try this download. Its a very simple design that you can follow. The filter fields only require you to type in few letters then use refresh to reset the listbox. When you obtain your data, just hit print. Let me know if this helps.